Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Role question.
I have tried and solve my problems, thanks a lot.
"~~~ Calvin K ~~~" <admorac_at_ctc.cl> ¼¶¼g©ó¶l¥ó
news:p_Ab7.20808$cy3.373489_at_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 - 13:59:26 CDT