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

Hi,

I think you must connect as the owner of dba_role_privs (i.e. "sys"), and grant select on the view to your application schema from within this account.

Regards

Michael Ringbo

Brandon Lee wrote:

> hi,
> 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 - 13:39:24 CET