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

      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