Re: Apex Security

On 2016/05/09 16:17, Woody McKay wrote:

> How do I best exclude a subset of tables from schema1 from showing up in schema2 (used as the apex parsing schema)?
>
> If I grant select on just one table in schema1 to schema2 and then go into Apex (schema2 is the parsing schema) -> App Builder -> Create Page -> Report -> Interactive Report -> Page -> Region Attributes, next, next and look at the table/View owner drop down list... ALL the tables from schema1 show up and you can create a report revealing all the table data. If I revoke the one grant select... then schema2 does not show up in the owner drop down list.

Not that I can necessarily help, but versions and web configuration would provide a starting point. APEX v5? Oracle DB v12? ORDS? Apache/mod_plsql?

Rich

--
http://www.freelists.org/webpage/oracle-l