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.
