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!

DB Authentication for a pool-specific config file

Pierre YottiFeb 1 2020 — edited Feb 3 2020

Hallo,

I have created a mapping URL to access my DB schema procedure with url. It works great. Here is an overview.

http://localhost:8080/ords/my_schema/sample_pkg.my_procedure

pastedImage_0.png

Now i enable DB authentication. Because i want that the user login before using the app. I added :

<entry key="jdbc.auth.enabled">true</entry>

in the pool config file my_schema.xml in ORDS config file

pastedImage_4.png

Calling http://localhost:8080/ords/my_schema/sample_pkg.my_procedure The login box is not displayed.

But i adding <entry key="jdbc.auth.enabled">true</entry> in /u01/ords/conf/ords/defaults.xml and calling my url like this http://localhost:8080/ords/sample_pkg.my_procedure it show the login Page and i can login with DB user/pass and see the App.

I need to have the DB Authentication for that url http://localhost:8080/ords/my_schema/sample_pkg.my_procedure

Any idea?

Thanks

Pierre Yotti

Comments
Post Details
Added on Feb 1 2020
2 comments
315 views