Re: what roles have been granted to a user?

you're looking for DBA_ROLE_PRIVS.

Here's a script to start you out.

select grantee, 'ROLE' privtype, granted_role privname, null owner, null table_name, admin_option grantable
from dba_role_privs
where grantee like upper('&WhichUser')
union
select grantee, 'SYSPRIV' privtype, privilege privname, null owner, null table_name, admin_option grantable
from dba_sys_privs
where grantee like upper('&WhichUser')
union
select grantee, 'TABPRIV' privtype, privilege privname, owner, table_name, grantable
from dba_tab_privs
where grantee like upper('&WhichUser')
order by 1, 2, 3, 4, 5

On Fri, 25 Feb 2005 11:18:05 -0800, sol beach <sol.beach_at_gmail.com> wrote:
> I know I should know how to do this, but I'm suffereing from senoritis.
>
> What query will show me which ROLEs have been GRANTed to a specific user?
> I can't seem to find the VIEW/TABLE which contains this information.
>
> TIA!
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l