Home » RDBMS Server » Security » VPD (ergent need, plz)
VPD (ergent need, plz) [message #433963] Sat, 05 December 2009 17:20 Go to next message
suvsuv
Messages: 1
Registered: May 2009
Junior Member
How i solve this ques?
Help me please -

Ques: Add a security policy that enforces column-level sensitivity to the EMPLOYEES table so that users can see all employee records in their department if they are not retrieving the Salary or BonusPct columns, but can only see their own record if they are querying these columns.

Describe: if users don't select two(Salary or BonusPct columns) columns, they can see all information from employees table. But when they want to see these two column they will see only their salary and bonus .

How i will do it?
Please help me?

Suvho
Re: VPD (ergent need, plz) [message #433964 is a reply to message #433963] Sat, 05 December 2009 20:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
When all else fails, Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/apdvpoli.htm#DBSEG13000

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

[Updated on: Sat, 05 December 2009 20:36]

Report message to a moderator

Re: VPD (ergent need, plz) [message #433967 is a reply to message #433963] Sun, 06 December 2009 00:46 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As this is your homework, show us what you alredy did.

Regards
Michel
Previous Topic: udump permissions to gropu other that dba
Next Topic: Query on OS Authentication
Goto Forum:
  


Current Time: Fri Mar 29 03:13:16 CDT 2024