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.
