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!

The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema

Ria_BMay 9 2019 — edited May 23 2019

Hi

I have an installation of  ords that use schema ORDS_PUBLIC_USER but when accessing the weburl I get:

The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named APEX_PUBLIC_USER

I don't want to use Oracle express and I don't think it's installed. Why does the error message refer to another schema?

To verify I ran

$ java -jar ords.war setup

Enter the name of the database server [localhost]:hostname

Enter the database listen port [1521]:

Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2

Enter the database SID [xe]:SID

Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:

Enter the database password for ORDS_PUBLIC_USER:

Confirm password:

Retrieving information.

Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.

If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:2

May 09, 2019 3:21:38 PM

INFO: reloaded pools: [|apex|pu|]

May 09, 2019 3:21:38 PM oracle.dbtools.rt.config.setup.SchemaSetup install

INFO: Oracle REST Data Services schema version 18.4.0.r3541002 is installed.

when logging in as ORDS_PUBLIC_USER I can't see any tables? Should I?

Thanks and best regards

Ria_B

This post has been answered by Ria_B on May 23 2019
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 5 2025
Added on May 9 2019
9 comments
8,396 views