Find Privileges Granted to a User in Oracle

 

It is possible to find the privileges granted to a user with the data dictionary views.

The main views that can be used are as follows:

For the privileges of all users:

  • ALL_COL_PRIVS
  • ALL_COL_PRIVS_MADE
  • ALL_COL_PRIVS_RECD
  • ALL_REPGROUP_PRIVILEGES
  • ALL_TAB_PRIVS
  • ALL_TAB_PRIVS_MADE
  • ALL_TAB_PRIVS_RECD

For our own privileges:

  • USER_AQ_AGENT_PRIVS
  • USER_COL_PRIVS
  • USER_COL_PRIVS_MADE
  • USER_COL_PRIVS_RECD
  • USER_REPGROUP_PRIVILEGES
  • USER_ROLE_PRIVS
  • USER_SYS_PRIVS
  • USER_TAB_PRIVS
  • USER_TAB_PRIVS_MADE
  • USER_TAB_PRIVS_RECD

You can query these views under any conditions.

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 *