Re: Select user from Dba_? where Granted_Role = 'myrole'?

Time

SELECT grantee
FROM dba_role_privs
WHERE granted_role='PEDIATRICS';

HTH. Pete

Tim Romano wrote:

> Is it possible to get a list of all users who have been granted a
> specified role? I don't mean a system-defined role, like
> RESOURCE, but an application-specific one. For example, suppose I
> create a role called PEDIATRICS and grant it to user JSMITH.
> Where can I find out whether JSMITH has been granted role
> PEDIATRICS?
> TIA,
> Tim Romano

--

Regards

Pete

Received on Mon Jun 07 1999 - 19:38:12 CDT