How To Check Object Privileges Granted to a Role or User in Oracle

To perform various operations on database objects, system and object privileges must be assigned to users.

Each system privilege allows a user to perform certain database operations.

Object privileges allow a user to execute specific operations on a specific object.

The following queries can be used to determine which system or object privileges are granted to which role or users:

Check System Privileges Granted to a Role or User

Check Object Privileges Granted to a Role or User

Using this query, a view similar to the DBA_SYS_PRIVS view can be generated as follows.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *