User roles


<br />
select<br />
	GRANTED_ROLE,<br />
	rp.ADMIN_OPTION,<br />
	DEFAULT_ROLE,<br />
	PRIVILEGE<br />
from   	dba_role_privs rp, dba_sys_privs sp<br />
where  	rp.GRANTEE = sp.GRANTEE<br />
and	rp.GRANTEE not in ('SYS','SYSTEM','DBA')<br />
and rp.grantee = upper('%&USERNAME%')<br />
order  	by  rp.GRANTEE, GRANTED_ROLE, PRIVILEGE<br />
/<br />

select 	
	GRANTED_ROLE,
	rp.ADMIN_OPTION,
	DEFAULT_ROLE,
	PRIVILEGE
from   	dba_role_privs rp, dba_sys_privs sp
where  	rp.GRANTEE = sp.GRANTEE
and	rp.GRANTEE not in ('SYS','SYSTEM','DBA')
and rp.grantee = upper('%&USERNAME%')
order  	by  rp.GRANTEE, GRANTED_ROLE, PRIVILEGE
/