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 -> Select user from Dba_? where Granted_Role = 'myrole'?

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

From: Tim Romano <tim_at_ot.com>
Date: Mon, 07 Jun 1999 20:14:58 -0400
Message-ID: <375C6081.33CE46AA@ot.com> 





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

Received on Mon Jun 07 1999 - 19:14:58 CDT












Original text of this message













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