2 Replies Latest reply: Sep 23, 2012 11:59 PM by 921598 RSS

    What is VPD?

    963842
      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
          See
          http://www.oracle.com/technetwork/database/security/index-088277.html
          http://docs.oracle.com/cd/B19306_01/network.102/b14266/apdvpoli.htm
          http://www.adp-gmbh.ch/ora/security/vpd/

          Edited by: HuaMin Chen on Sep 24, 2012 12:52 PM
          • 2. Re: What is VPD?
            921598
            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.
            http://dbmentors.blogspot.com/2006/01/virtual-private-databases-vpd.html

            Regards
            Inam Bukhari
            http://dbmentors.blogspot.com