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?