Home Discussions Questions & Answers Developer Access to Sensitive Data via VPD Policies

Developer Access to Sensitive Data via VPD Policies

Avatar photoCustomer August 12, 2020 at 11:41 pm

We implemented Oracle VPD via Blitz Report to secure sensitive HR data. If a select few developers need to bypass this restriction for maintenance, how do we grant them full access?

Viewing 4 reply threads
  • Author
    Replies
    • Support August 13, 2020 at 10:07 am  

      You can optionally set the profile option ‘Blitz Report VPD Policy Rule’ to control data access on secured tables.

    • Avatar photoCustomer August 13, 2020 at 2:58 pm  

      What specific setting provides the bypass access?

    • Support August 14, 2020 at 2:08 pm  

      You should set the profile option ‘Blitz Report VPD Policy Rule’ to ‘Full access’ at the user or responsibility level for those who need access to run Blitz Reports on secured data.

    • Avatar photoCustomer August 15, 2020 at 11:52 am  

      Does this VPD policy secure data access through other tools like SQL Developer?

    • Support August 15, 2020 at 7:39 pm  

      No, this method secures data access only through the Blitz Report concurrent program, not through direct queries using database access tools or standard Oracle EBS processes.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: