Select Usuario,Permissao
from(
Select x.Grantee As Usuario ,y.Granted_Role As Permissao
From Dba_Role_Privs X
join Role_Role_Privs y on y.Role = x.Granted_Role
union all
Select x.Grantee As Usuario ,y.PRIVILEGE As Permissao
From Dba_Role_Privs X
join Role_sys_Privs y on y.Role = x.Granted_Role
)
where usuario = upper(:usuario)
order by usuario desc
select drp.grantee as usuario
ResponderExcluir,rsp.privilege as permissao
from dba_role_privs drp
,role_role_privs rrp
,role_sys_privs rsp
where drp.granted_role = rrp.role
and drp.granted_role = rsp.role
and drp.grantee = upper(&usuário);