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