Re: finding out the roles

From: Rich Goldkamp <rjgoldka_at_dcss.com>
Date: 8 Apr 1999 16:07:00 GMT
Message-ID: <01be81df$7c0d7760$3a0710ac@c-rgoldkam-w95.laitram.com>

SELECT	grantee, granted_role, admin_option
FROM		dba_role_privs
WHERE	grantee	= 'USERNAMEHERE';

Cheers,
Rich
--
Rich Goldkamp, OCP RJGoldka_at_dcss.com
Digital Consulting & Software Services
(504) 523-5005 x2736

Joerg Leute <leute_at_itdesign.de> wrote in article <7ei8f8$1c8$1_at_news.LF.net>...
> 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:07:00 CDT