Oracle – Check User Privileges

Oracle – Check User Privileges

If you want to check that a user has been granted/revoked the correct privileges you can perform the following from SQLPLUS:

SQL> SELECT grantee, privilege FROM dba_sys_privs WHERE grantee = '<username>' ORDER BY privilege;

To check a group of similar users have the same number of privileges quickly you can perform a count of their privileges:

SQL> SELECT grantee, COUNT(privilege) FROM dba_sys_privs GROUP BY grantee;