Query DBA_ROLE_PRIVS for roles, DBA_SYS_PRIVS for system privileges and DBA_TAB_PRIVS for object privileges.