How to create new database user ?

Creating new database user

1. Login with database user for example: oracle

2. Goto SQL prompt using sqlplus commnd.

  Oracle$ sqlplus /nologs

3. At SQL prompt, Connect as system Database administrator.

  Sql> connect as sysdba

4. Enter database username and password.

  Enter user-name: oracle

  Enter password:  oracle1234

5. Create database user by giving username and password.

  Sql> create user db_test identified by test123;

6. Grant connection and resources to the newly created user.

  Sql> grant connect,resource to db_test;

7. Disconnect from oracle.

  Sql> quit