Re: where is role data stored?

Chuck,

DBA_TAB_PRIVS should have what you're looking for, where grantee = 'APPL_ROLE'

Regards,
Charles_Dye_at_corp.dialog.com

In article <4aa4st$g3_at_ixnews4.ix.netcom.com>, chuckh_at_ix.netcom.com (Chuck Hamilton) writes:
> I created a role called APPL_ROLE and granted several privileges to
> it: connect, create table, etc. Now I'd like to query the role to see
> what privileges it has but I can't find it anywhere. It's not in
> ROLE_ROLE_PRIVS, ROLE_SYS_PRIVS, or ROLE_TAB_PRIVS. Yet it does show
> up in DBA_ROLES. Where's the specific privileges for this role stored?
> --
> Chuck Hamilton
> chuckh_at_ix.netcom.com
>
> Never share a foxhole with anyone braver than yourself!
>
Received on Fri Dec 08 1995 - 00:00:00 CET