Question about Roles

From: Jim Katsos <jkatsos_at_oz.quests.com>
Date: Fri, 21 Jan 2000 05:42:50 GMT
Message-ID: <ulSh4.1595$fQ3.3524@news-server.bigpond.net.au>

Two question really ! (there tougher than they seem)

1.Using the dba_% views or otherwise. How can I distinguish between oracle system roles i.e CONNECT and those created by the 'CREATE ROLE' command.

I can't do this using DBA_ROLES.

2. Once I have distinguished these I would like to know what sys privs,tab privs or for that matter other roles these roles actually have granted to them. Yes. I know about

ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS

but these don't seem to have the info I need. (I've got a headache)

Any help would be appreciated.

--
Jim Katsos
Quest Software Pty Ltd
http://www.quests.com
tel +61 3 9811 8068
mob 0411088578 Received on Thu Jan 20 2000 - 23:42:50 CST