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!

Can OAUTH2 be used to Authenticate ORDS REST Enabled SQL?

User_T2LL6Mar 17 2022 — edited Mar 17 2022

Can OAUTH2 be used to Authenticate ORDS REST Enabled SQL (for use with APEX)? Our REST enabled SQL only works with basic auth. When we create an OAUTH2 client, assign it our ords database role, and give it the SQL Developer privilege, but it won't work.
We use OAUTH2 Authentication for our REST web service APIs developed in ORDS, so this is puzzling. The documentation for REST enabled SQL seems conflicting. Any help would be appreciated.

Comments

Post Details

Added on Mar 17 2022
3 comments
767 views