To add more to it, login to the schema name and then run
Select * from session_roles to check the default roles given to that
schema.
With Regards,
Amar P Singh
-----Original Message-----
From: Mohit Singla
[mailto:oracledba-ezmlmshield-x34880838.[Email address protected]
Sent: Monday, May 08, 2006 8:42 AM
To: LazyDBA Discussion
Subject: RE: Roles
Select * from dba_role_privs where grantee='<USERNAME>';
Regards and Thanks
Mohit Singla
-----Original Message-----
From: Brett N Exton
[mailto:oracledba-ezmlmshield-x91970948.[Email address protected]
Sent: Friday, May 05, 2006 8:02 AM
To: LazyDBA Discussion
Subject: Roles
Hopefully a quick and easy one for somebody....
What's the SQL for determining somebody's role ?
--
Brett Exton.
________________________________________________________________________
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
--------
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
Oracle LazyDBA home page