dba_users for the general user data, dba_tab_privs for his
object_authorizations and dba_sys_privs for his system_privileges;
dba_role_privs for his
granted roles
Hans
-----Original Message-----
From: Brett N Exton
[mailto:oracledba-ezmlmshield-x65334385.[Email address protected]
Sent: donderdag 11 mei 2006 15:49
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
-----------------------------------------------------------------
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