Home -> Usenet -> comp.databases.oracle -> where is role data stored?

where is role data stored?

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/12/08
Message-ID: <4aa4st$g3_at_ixnews4.ix.netcom.com>#1/1 






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












Original text of this message