4 Replies Latest reply on May 23, 2019 8:43 AM by Ria_B

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

Ria_B May 9, 2019 2:49 PM

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

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

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

thatJeffSmith-Oracle May 9, 2019 3:16 PM (in response to Ria_B)

>> but when accessing the weburl I get
which URL?

>>I don't want to use Oracle express and I don't think it's installed
if you don't have a DB, that's going to be a problem

>>when logging in as ORDS_PUBLIC_USER I can't see any tables? Should I?
No, and you shouldn't be logging in as that user either. That's the user ORDS uses to access REST enabled schemas for running the workload behind your RESTful Services. It's a proxy account to get to the real database users.
Like Show 0 Likes(0)

Actions
2. Re: The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named APEX_PUBLIC_USER

Ria_B May 10, 2019 7:00 AM (in response to thatJeffSmith-Oracle)

Hi
Sorry for being unclear. I have ords.war installed on an weblogic server on a separate host than the database. I try to access
http://hostname:8001/ords/receipt
Where hostname is the name of the weblogic appserver that runs run port 8001.
Then I get
503 service unavailable
The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named APEX_PUBLIC_USER

I have granted the schema user where the table receipt resides to ORD_PUBLIC_USER
alter user dev grant connect through ords_public_user;

I have rest enabled the schema and table via sqldeveloper.

I meant that apex is not installed. Why does the error message refer to APEX_PUBLIC_USER?
I have no such schema in the database only ORDS_PUBLIC_USER and ORDS_METADATA.

Thanks and Best regards
Ria_B
Like Show 0 Likes(0)

Actions
3. Re: The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named APEX_PUBLIC_USER

thatJeffSmith-Oracle May 10, 2019 11:23 AM (in response to Ria_B)

what is /ords/receipt?
Like Show 0 Likes(0)

Actions
4. Re: The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named APEX_PUBLIC_USER

Ria_B May 23, 2019 8:43 AM (in response to thatJeffSmith-Oracle)

Hi
I had missed the schema name. The path should be /ords/dev/receipt. My guess why the error message says APEX_PUBLIC_USER is that someone had installed apex and then removed it.
Thanks and best regards
Ria_B
Like Show 1 Likes(1)

Actions

Go to original post