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.