You can try this ...

select GRANTEE usr, GRANTED_ROLE
from DBA_ROLE_PRIVS


----- Original Message -----
From: "Iqbal Mohammed "
<oracledba-ezmlmshield-x43682742.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, December 01, 2005 1:48 PM
Subject: User & Roles


> Hi,
>
>
>
> Can any one provide a query to find out User viz Roles in Oracle
>
>
>
>
>
> Regs
>
>
>
>
>
> DBA
>
> The information transmitted and available in this message is intended
> only for the person or entity to which it is addressed and may contain
> confidential and/or privileged information/material.
> Any review, retransmission, dissemination or other unauthorized use of,
> or taking of any action in reliance upon this information by persons or
> entities other than the intended recipient are strictly prohibited
> and unlawful. If you have received this in error, please delete the
> message and/or material immediately and contact ADCB as below for
> appropriate action.
>
>
> Abu-Dhabi Commercial Bank, P.O.Box, 2800 Abu Dhabi, UAE
> Email:[Email address protected] Tel: +971-2-6733342 Fax: +971-2-6109700"
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --
> This message has been scanned for viruses and
> dangerous content, and is believed to be clean.
>


Oracle LazyDBA home page