||Oracle Tips by Burleson
Oracle 10g Column-Level Privacy
Virtual Private Database provides row-level
security (RLS). Oracle 10g will only enforce row-level access
control when a SQL statement accesses security-relevant columns.
You can specify multiple columns in a policy. If relevant columns
are specified for an object in a policy, then VPD rewrites all SQL
statements referenced to the object.
The following table employees in the Sample HR
schema will be used in our VPD examples:
Get the complete story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details: