How to create Schema/User in oracle using command prompt

Here are the commands to create user

Login to oralce and get sql command prompt
c:> sqlplus id/password

SQL:>

 

Syntax:

   CREATE USER username
      IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'external_name'}
         options;
create user premaseem identified by prem_secret_password;
create user premaseem identified externally;
create user premaseem identified globally as 'external_name';

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s