want to have a list of users who have been granted a specific role?

From: Brandon Lee <brand_at_tm.net.my>
Date: Tue, 9 Mar 1999 10:07:03 +0800
Message-ID: <36e4829f.0_at_news.tm.net.my>

hi,
[Quoted]   i am new to oracle db and i am wondering how to let an ordinary user to query the dba data dictionary; specifically i want my application schema to provide a list of user who have been granted a role (say 'manager'). i know i can do something like this using 'system' user:

select grantee
from dba_role_privs
where granted_role ='MANAGER';

but this statement can only be run by system user. i tried granting select on dba_role_privs to the application user but it says insufficient privileges. can anyone help? Received on Tue Mar 09 1999 - 03:07:03 CET