ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS 3.0 - How to set VPD Context before executing SQL Template?

roger_eFeb 9 2015 — edited Feb 19 2015

I need to set a couple of attributes in an Oracle Session Context before the SQL/PLSQL template handler is executed, as we rely on Oracle VPD/Row-Level-Security for the data access.

Is there a hook/functionality in ORDS 3.0 where I can register a PL/SQL (e.g. set_security_context(authenticated_user)) procedure, so this 'set_security_context' procedure is executed before and for each execution of a SQL/PLSQL template handler?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2015

Added on Feb 9 2015

3 comments

1,369 views