Friday, May 6, 2016

Query APEX dictionary views from non-parsing schema

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!

Tested in APEX 5.0.3.00.03

1 comment:

  1. I would suggest grant SELECT ANY DICTIONARY, or SELECT on specific view only to the parsing schema.
    In my opinion it's more secure option.

    ReplyDelete