please query dba_users to find existing users default & temporary tablespaces.

Query dba_roles,dba_role_privs & dba_sys_privs to get the roles & provileges granted to existing user.

Then you go...create user .....

Deepak.

________________________________

From: Imran KHAN [mailto:oracledba-ezmlmshield-x48320142.[Email address protected]
Sent: Mon 9/4/2006 09:54
To: LazyDBA Discussion
Subject: Create a user



Hi gurus,

I wana create user like any existing user along with all
priviliges and roles.



Regards

Khan

..





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.

Oracle LazyDBA home page