4 Replies Latest reply on Feb 26, 2019 10:32 PM by Fazha

    ORDS - Exposing a schema through a proxy account


      We have been setting up ORDS to enable the owner schema as (therefore exposing all objects owned by the schema to ORDS), but is there a way to enable a PROXY account (ie a non owner account that only has permissions on certain objects in the owner schema)?


      For example, we have a schema ESS that ownes all of the tables, procedures etc. However, we only want to expose one particiular package in that schema to ORDS. Could we create a second account, say ESSWEB, that only has execute on that package, and then enable ESSWEB with ORDS?


      Has anyone tried this approach?