SQL>break on grantee
SQL>select grantee, granted_role from dba_role_privs where grantee like
'SYS%' ;

GRANTEE GRANTED_ROLE
------------------------------ ------------------------------
SYS AQ_ADMINISTRATOR_ROLE
AQ_USER_ROLE
CONNECT
DBA
DELETE_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
EXP_FULL_DATABASE
HS_ADMIN_ROLE
IMP_FULL_DATABASE
MONITOR_ROLE
NO_LOGON_CHECK
OEM_MONITOR
PLUSTRACE
RECOVERY_CATALOG_OWNER
REPORT_WRITER
RESOURCE
SELECT_CATALOG_ROLE
SNMPAGENT
SYSTEM AQ_ADMINISTRATOR_ROLE
DBA
EKIP

GRANTEE GRANTED_ROLE
------------------------------ ------------------------------
SYSTEM EKIP_SELECT
NO_LOGON_CHECK
RESOURCE

24 rijen zijn geselecteerd.

SQL>

-----Original Message-----
From: Brett N Exton
[mailto:oracledba-ezmlmshield-x52375699.[Email address protected]
Sent: donderdag 11 mei 2006 13:38
To: LazyDBA Discussion
Subject: SQL


The table dba_role_privs has two columns (GRANTEE and GRANTED_ROLE)

I am trying to write an SQL script which will select one occurance of
GRANTEE followed by all of the GRANTED_ROLE's that a user has

e.g My self: BRETT, RESOURCE, CONNECT,...,... etc

Come somebody help !

--
Brett


________________________________________________________________________
This e-mail and any attachments transmitted with it represents the views
of the individual(s) who sent them and should not be regarded as the
official view of Bridgend County Borough Council. The contents are
confidential and intended solely for the use of the addressee. If you
have received it in error, please inform the system administrator on
(+44) 01656 642111.

This e-mail and any attachments have been scanned with 'MessageLabs
SkyScan' - http://www.messagelabs.com/

________________________________________________________________________
Maer'r e-bost hwn ac unrhyw atodiadau a drosglwddir gydag ef yn
cynrychioli safbwyntiau'r unigolyn (unigolion) a'u hanfonodd ac ni
ddylid eu hystyried fel safbwynt swyddogol Cyngor Bwrdeistref Sirol
Pen-y-bont ar Ogwr. Mae'r cynnwy syn gyfrinachol ac wedi'i fwriadu at
ddefnydd y person y'i cyfeiriwyd ato yn unig. Os ydych wedi ei dderbyn
mewn camgymeriad, rhowch wybod i weinyddwry system ar (+44) 01656
642111.

Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda
'MessageLabs SkyScan' - http://www.messagelabs.com/
________________________________________________________________________


--------
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
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page