What is the difference between Oracle9i VPD and Oracle9i Label Security?
Oracle9i VPD is provided at no cost with the Oracle9i Enterprise Edition. Oracle9i Label Security is an add-on security option for the Oracle9i Enterprise Edition. Oracle VPD is a term used for several powerful Oracle9i Enterprise Edition security features – fine grained access control (FGAC), application context and global application context. FGAC refers to policies written using PL/SQL. FGAC policies can be assigned to an individual table or view. Information requests which reference tables and views protected by FGAC are modified according to the FGAC policy assigned to the table or view. FGAC policies can be as simple as enforcing access during business hours. FGAC policies can be written which restrict access by comparing the value of an attribute in an individual row with a VPD application context value. Global application context allows an application context to be accessed across multiple database sessions, reducing or eliminating the need to create a separate application cont
