| Hiding UnApproved Data to Users [message #521642] |
Wed, 31 August 2011 13:05  |
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  |
 |
Littlefoot
Messages: 21823
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 ascreate view approved_data as
select col1, col2, col3, ...
from your_table
where cb_approved = 1 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
