Re: Defined Roles

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 02 Nov 2004 09:17:05 -0600
Message-ID: <1099408531.tSbpsrTvWRplZSHlvCecyQ@teranews>

dbennet_at_gmail.com wrote:

>I need to print the defined roles and users for our Oracle databases
>(vs 7.3.3)., preferably also a list of roles and who belongs to the
>roles. This needs to be done for our auditors.
>
>I am not a DBA, so I am not overly fimiliar with Oracle, and am hoping
>to save a bit of money by not having our vendor do this for us.
>Thanks.
>
>Darryl

There are several views ( at least in modern ( meaning post 7) versions of Oracle ): USER_ROLE_PRIVS
DBA_ROLES

ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS

SESSION_ROLES ..

Try them to see which works best for what you need..

Some may require DBA privs to access. Received on Tue Nov 02 2004 - 09:17:05 CST