ORDS 18.2 – The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named

ORDS Version : 18.2
Oracle Version : 12cR2

Error : The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named HR

Desc: The error occurs when you have published a RESTful web service from a table inside a schema. When you try to call the Webs service it gives an internal error, because the schema does not have proxy connect privilege to the ORDS public user.

Solution : Grant the username connect through privilege

SQL> alter user HR grant connect through ords_public_user;

Now try calling the REST service again and it should return the valid result set.

Leave a Reply