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

Home -> Community -> Usenet -> c.d.o.misc -> Re: finding out the roles

Re: finding out the roles

From: XU <xux_at_informa.bio.caltech.edu>
Date: 8 Apr 1999 16:38:06 GMT
Message-ID: <7eim1e$efb@gap.cco.caltech.edu> 





select granted_role from dba_role_privs where grantee='USERNAME';




Robert XU




Joerg Leute (leute_at_itdesign.de) wrote:


: Hi everybody





: is there any way i can find out which roles are assigned to a user? (i mean


: by an sql-statement, not in the GUI)





: Thanks in advance





: Joerg





Received on Thu Apr 08 1999 - 11:38:06 CDT












Original text of this message













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