Home » RDBMS Server » Security » VPD (ergent need, plz)
VPD (ergent need, plz) [message #433963] Sat, 05 December 2009 17:20 Go to next message
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?

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
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
When all else fails, Read The Fine Manual


You need to help us by following the Posting Guidelines as stated below.
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: 68264
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As this is your homework, show us what you alredy did.

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

Current Time: Thu Aug 18 18:07:04 CDT 2022