Skip to Main Content

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!

Has anyone successfully had an ORDS prehook trigger run on an ORDS OAUTH2 protected endpoint?

user12002080Jun 9 2024

Using ORACLE ORDS 23.4 on an on-premise ORACLE 19 database.

Have tried this on both standalone and tomcat environments.

Endpoint protected by ORDS OAUTH privilege/role. Prehook unconditionally inserts into a log table. Get the expected 401 as user not yet authenticated, but nothing in log. If I unprotect the endpoint I get a log entry. Suggesting that the prehook doesn't fire if user not authenticated.

This post has been answered by alacourb on Jun 17 2024
Jump to Answer
Comments
Post Details
Added on Jun 9 2024
2 comments
657 views