Stack Overflow
Stack Overflow

Questions tagged [vpd]

Use this tag for questions dealing with Oracle Fine Grained Access Control and the `DBMS_RLS` package,

Virtual Private Database is an Oracle security feature which restricts the data which users can see and/or change. Security policies are defined for database tables, which create filters that are applied automatically to DML statements.

18 questions
0
votes
1 answer

Oracle Virtual Private Database (VPD): trigger privileges / function generates invalid predicate

Two questons during creation of Virtual Private Database. Which privileges are needed to run a database logon trigger? The users need special privileges? Error message: problem with the function, but the function works well. The codes from the…
diaphol
  • 117
  • 1
  • 9
0
votes
1 answer

Oracle VPD Session issue with Tomcat JDBC

My goal is to be able to create 'Isolated sessions' using Tomcat JDBC with Oracle VPD. How do I achieve concept similar to SessionEventAdapter in Eclipse Link but with more Tomcat Connection Pool. My current client code below: InitialContext initCtx…
Phani
  • 5,319
  • 6
  • 35
  • 43
0
votes
2 answers

Prevent current user from seeing their record? VPD - ORACL12C

I am trying to create a function that will prevent the current logged in user from viewing their own record in the scott.emp table. I have written a function to enforce the policy. Currently the return statement is return 'ename != CURRENT_USER';…
Mark D
  • 257
  • 5
  • 6
  • 12
1
2