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: find out the role of a user

Re: find out the role of a user

From: Juhan Kundla <juhan_at_ensib.ee>
Date: Thu, 08 Apr 1999 16:23:51 +0300
Message-ID: <370CADE7.6D63119E@ensib.ee>


Joerg Leute 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

select * from dba_role_privs
where grantee = user;

Juhan Received on Thu Apr 08 1999 - 08:23:51 CDT

Original text of this message

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