Query the view dba_users to start.
-----Original Message-----
From: Brett N Exton
[mailto:oracledba-ezmlmshield-x65334385.[Email address protected]
Sent: Thursday, May 11, 2006 7:49 AM
To: LazyDBA Discussion
Subject: Where's my user been created ?
I have just run an SQL to create a USER:
SQL> create user "BCBC\AGOLD" identified externally default tablespace
SQL> users
temporary tablespace temp;
User created.
SQL> SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'BCBC\AGOLD';
no rows selected
Where are my user's details being held ?
--
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
Oracle LazyDBA home page