Home » RDBMS Server » Security » Hiding UnApproved Data to Users (Oracle 10G)
Hiding UnApproved Data to Users [message #521642] Wed, 31 August 2011 13:05 Go to next message
m_maruthu
Messages: 8
Registered: July 2010
Location: UK
Junior Member
Hi Experts,

We've a requirement to hide particular data set for users, until it's reviewed & approved by admin. This needs to be implemented in our live environment (BO WebI 3.1 and Oracle 10G). We explored below options on the db side but obviously it will increase the maintenance efforts:

1. Implement data level security using Virtual Private Database (VPD) and some flag indicators.
2. Storing approved and unapproved data in different db partitions

Wanted to check if there is there a quick option available to achieve this.? Any inputs will be greatly appreciated!

-MP

Re: Hiding UnApproved Data to Users [message #521649 is a reply to message #521642] Wed, 31 August 2011 14:35 Go to previous messageGo to next message
Littlefoot
Messages: 21481
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Obviously, you can distinguish approved data from unapproved. Let's suppose that there's a column CB_APPROVED in a table, whose value is 1 if data is approved, and 0 if it is not approved. Perhaps you could create a view, such as
create view approved_data as
select col1, col2, col3, ...
from your_table
where cb_approved = 1
and let users work with that view (i.e. base form's data blocks on a view (instead of a table), report's queries should select from a view (instead of a table), and so on.
Re: Hiding UnApproved Data to Users [message #521650 is a reply to message #521649] Wed, 31 August 2011 14:38 Go to previous message
BlackSwan
Messages: 26538
Registered: January 2009
Location: SoCal
Senior Member
>Wanted to check if there is there a quick option available to achieve this.? Any inputs will be greatly appreciated!
place the unapproved data in a different schema
Previous Topic: audit issue
Next Topic: Unable to see data in base table where as data can be viewed in synonym.
Goto Forum:
  


Current Time: Tue Jun 18 23:44:28 CDT 2019