Oracle – SQLPlus – Create new User



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.



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


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



Connect as SYS


SQL> connect SYS as SYSDBA


Output – Connecting …

Output – Connected


Create User


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.


connect msftbids


2 thoughts on “Oracle – SQLPlus – Create new User

Leave a Reply

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

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