||Oracle Tips by Burleson
Oracle 10g Virtual Private Database
Column-Level Privacy - It increases
performance by limiting the number of queries that the database
rewrites. Rewrites only occur when the statement references
relevant columns. This feature also leads to more privacy.
Customization - With the introduction of
four new types of policies, you can customize VPD to always enforce
the same predicate with a static policy or you can have VPD
predicates that change dynamically with a non-static policy.
Shared Policies - You can apply a single
VPD policy to multiple objects, and therefore reduce administration
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: