Check Privileges assigned to any Schema

Share

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:

Queries:

-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?

Share
About Dhiraj 52 Articles
Blogger on development, securities, and efficiency on web technologies.

Be the first to comment

Leave a Reply

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