How to find all granted privileges to users

Sometimes it becomes necessary to find all the granted privileges to users, especially during auditing. Lets see how

SQL> select grantee, privilege from dba_sys_privs where grantee = 'GGADMIN';

GRANTEE                        PRIVILEGE
------------------------------ ----------------------------------------
GGADMIN                        DROP ANY DIRECTORY
GGADMIN                        SELECT ANY TABLE
GGADMIN                        FLASHBACK ANY TABLE
GGADMIN                        CREATE ANY DIRECTORY
GGADMIN                        ALTER ANY TABLE
GGADMIN                        SELECT ANY DICTIONARY
GGADMIN                        RESTRICTED SESSION
GGADMIN                        ALTER SESSION
GGADMIN                        CREATE SESSION
GGADMIN                        UNLIMITED TABLESPACE
Comments