How to find the grantees of a role
From: Peter Kallweit <p_kallweit_at_arcor.de>
Date: Fri, 09 Jul 2010 09:33:55 +0200
Message-ID: <4c36d0e3$0$6761$9b4e6d93_at_newsspool3.arcor-online.net>
Hi %,
Date: Fri, 09 Jul 2010 09:33:55 +0200
Message-ID: <4c36d0e3$0$6761$9b4e6d93_at_newsspool3.arcor-online.net>
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
Received on Fri Jul 09 2010 - 02:33:55 CDT