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