RE: Role question.

From: ~~~ Calvin K ~~~ <admorac_at_ctc.cl>
Date: Mon, 6 Aug 2001 13:59:27 -0400
Message-ID: <p_Ab7.20808$cy3.373489@maule>

select grantee, owner, table_name, grantor,privilege, grantable from dba_tab_privs

select

dba_role_privs.grantee,
role_tab_privs.owner,
role_tab_privs.table_name,
role_tab_privs.Privilege,
role_tab_privs.grantable
from dba_role_privs, dba_role_tab_privs

where dba_role_privs.grante_role = role_tab_privs.role and dba_role_privs.grantee = 'some username'

Atte.
Larry.

Jordan <mj_at_nba.com> escribió en el mensaje de noticias 9kmi51$m942_at_imsp212.netvigator.com...
> What data dictionary or dynamic view that let me know who user has been
> assigned to which role(s)? Thanks.
>
>
Received on Mon Aug 06 2001 - 12:59:27 CDT