Re: Systemtable where roles are specified

From: KEVIN COOK <KEVINCOOK_at_ATT.NET>
Date: Sun, 18 Apr 1999 17:03:56 -0600
Message-ID: <371A64DC.75E505EB@ATT.NET>

Pete Sharman wrote:
>
> Thomas
>
> There's a couple of things we need to know, because you're mixing some
> terminology here. Do you want to find out what roles exist, in which case
> you can use DBA/ALL/USER_ROLES to see what's there, SESSION_ROLES to see
> what's active, DBA/ALL/USER_ROLE_PRIVS to see the actual privileges
> granted? OR are you after direct grants to users, rather than through
> roles, in which case DBA/ALL/USER_TAB_PRIVS are the views to look at?
>
> Just a minor point in addition - 7.3.5 doesn't exist to my knowledge. 7.3.4,
> or 7.3.3.5, yes.
>

You are correct ... the 3 views for privs are XXX_tab_privs, XXX_role_privs
XXX_sys_privs where XXX is DBA, ALL or USER

According to Metalink <Note:66409.1> ... Release 7.3.4 is the terminal release for Oracle7....

-Kevin Cook Received on Sun Apr 18 1999 - 18:03:56 CDT