Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select user from Dba_? where Granted_Role = 'myrole'?

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

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 07 Jun 1999 17:38:12 -0700
Message-ID: <375C65F4.EDE2BD23@us.oracle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US