Re: How to find the grantees of a role
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 9 Jul 2010 07:28:36 -0700 (PDT)
Message-ID: <f0d23a0c-4c37-4d76-97b2-e79df89def1a_at_w12g2000yqj.googlegroups.com>
On Jul 9, 3:33 am, Peter Kallweit <p_kallw..._at_arcor.de> wrote:
> Hi %,
>
> I have a user to which a role has been granted with admin option. So
> this user now can grant/revoke this role to/from other users.
>
> But how can this user find out, to which other users this role is
> currently granted?
>
> As a DBA, one would use the view DBA_ROLE_PRIVS. But what, if the access
> to the dba_xxx views is not available? I'm missing a view like
> ALL_ROLE_PRIVS (not found in 9i, 10g, 11g).
>
> Any ideas?
>
> Best regards
> Peter
Date: Fri, 9 Jul 2010 07:28:36 -0700 (PDT)
Message-ID: <f0d23a0c-4c37-4d76-97b2-e79df89def1a_at_w12g2000yqj.googlegroups.com>
On Jul 9, 3:33 am, Peter Kallweit <p_kallw..._at_arcor.de> wrote:
> Hi %,
>
> I have a user to which a role has been granted with admin option. So
> this user now can grant/revoke this role to/from other users.
>
> But how can this user find out, to which other users this role is
> currently granted?
>
> As a DBA, one would use the view DBA_ROLE_PRIVS. But what, if the access
> to the dba_xxx views is not available? I'm missing a view like
> ALL_ROLE_PRIVS (not found in 9i, 10g, 11g).
>
> Any ideas?
>
> Best regards
> Peter
Peter, the link below is to a short article that identifies most the Oracle security related views that you access to see who has access to what:
How do I find out which users have the rights, or privileges, to access a given object ? http://www.jlcomp.demon.co.uk/faq/privileges.html
See view dba_role_privs to see who has been granted a role.
HTH -- Mark D Powell -- Received on Fri Jul 09 2010 - 09:28:36 CDT