Check Privileges assigned to any Schema


Oracle Database allows several views that can be queried in order to obtain the list of privileges to any user, schema, role. In order to check assigned privileges in Oracle, we might have to query against several views available. Although, these tests were performed on Oracle 11g XE, these views might be available on other platforms.

A little brief about data dictionary view prefix:

Useful views information:


-About user/schema status

-Check the assigned roles to role and schema

-Check the role privileges

-Check privileges of granted objects for schema


Would You Mind Sharing?


Be the first to comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.