select * from ( select granted_role, grantee from dba_role_privs union select PRIVILEGE, GRANTEE from dba_sys_privs ) where grantee = 'PBADMIN'; evtl noch sys_tab_privs integrieren