2 Replies Latest reply: Sep 23, 2012 11:49 PM by 963842 RSS

    What is VPD?

      I've come across that VPD can be used for the security purpose. What is it and any helpful link about it? Kindly share.
        • 1. Re: What is VPD?
          HuaMin Chen

          Edited by: HuaMin Chen on Sep 24, 2012 12:52 PM
          • 2. Re: What is VPD?
            Oracle Virtual Private Database (VPD) allows you to create security policies to control the access at the row and column level. These security policies are enforced by the database rather than an application, which means that use of a different application will not bypass the security policy.

            Oracle adds dynamically and transparently a WHERE clause( predicate ) to a SQL statement that is executed against the object (table, view or synonym) to which a VPD policy was applied. The predicate (WHERE clause) is returned by a custom function which implements the security policy. It is your responsability to write correctly this function so that it will return the expected predicates in various scenarios.

            An example on my blog may help to understand the concept.

            Inam Bukhari