You may have noticed that if you query any of the APEX's dictionary views (APEX_*) outside the parsing schema you won't get any rows. There's quick solution for this. You only have to grant APEX_ADMINISTRATOR_ROLE to this schema.
grant APEX_ADMINISTRATOR_ROLE to your_nonparsing_schema;
Be careful, user with this role can execute APEX_INSTANCE_ADMIN package procedures and functions.
Enjoy!
grant APEX_ADMINISTRATOR_ROLE to your_nonparsing_schema;
Be careful, user with this role can execute APEX_INSTANCE_ADMIN package procedures and functions.
Enjoy!
Tested in APEX 5.0.3.00.03
I would suggest grant SELECT ANY DICTIONARY, or SELECT on specific view only to the parsing schema.
ReplyDeleteIn my opinion it's more secure option.