Amit,

Are you trying to create a user within a stored procedure? A
schema is a user before it becomes a schema. The major difference
between a user and a schema user is that a schema user owns objects
whereas a user normally has access privileges to some or many user
schema objects. A user is a user until the user is granted the necessary
privileges to create objects.

IJCA,
Gil Bruce

-----Original Message-----
From: amit1
[mailto:oracledba-ezmlmshield-x74191326.[Email address protected]
Sent: Thursday, January 31, 2008 12:28 AM
To: LazyDBA Discussion
Subject: Schema



If we do't have script for creating Schema(User ) then wht is the other
possible way to create it .




Regards


Amit


***********************
No virus was detected in the attachment no filename No virus was
detected in the attachment no filename

Your mail has been scanned by InterScan.
***********-***********


************************************************************************
************************************************************************
*********************
"This message and any attachments are solely for the intended recipient
and may contain Birlasoft confidential or privileged information. If you
are not the intended recipient,any disclosure,copying, use, or
distribution of the information included in this message and any
attachments is

prohibited. If you have received this communication in error, please
notify us by reply e-mail at ([Email address protected] and permanently
delete this message and any attachments. Thank you."
************************************************************************
************************************************************************
*********************


---------------------------------------------------------------------
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



Oracle LazyDBA home page