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;