How to find all user Roles and Privileges?

Here is the scripts to help you to get this information: PROMPT  PROMPT  PROMPT ******************************************** ROLES AND PRIVILEGES  PROMPT  PROMPT ******************************************** USER ROLES  SELECT grantee user, granted_role, admin_option, default_role  FROM dba_role_privs  WHERE grantee IN (SELECT username FROM dba_users) AND       grantee Continue reading