Oracle – SQLPlus – Create new User

 

Background

Now that we have Oracle DB Express installed, let us create a new normal user.

The reason being that there are some hoops you have to jump over if you try to use the sys or sysdba system accounts.

 

SQLPLus

There is a minimalist Client bundled with Oracle XE, it is called SQLPlus.

Launch

To launch on Windows access menu and underneath “Oracle Database 11g Express Edition” \ “Run SQL Command Line“.

 

Use

Connect as SYS

SQL


SQL> connect SYS as SYSDBA

Output

Output – Connecting …

Output – Connected

 

Create User

SQL


create user msftbids identified by mylittpwd;
grant connect to msftbids;

Connect User

Please launch another SQLPlus session and attempt to connect as the user you just created.

SQL


connect msftbids

Output

2 thoughts on “Oracle – SQLPlus – Create new User

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s