How to create user in database.

This document describes how to create user in oracle database.....

Create  user:

[oracle@server1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 3 22:22:05 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> create user adam identified by welcome;

User created.


Connect to user:

SQL> conn adam/welcome
ERROR:
ORA-01045: user ADAM lacks CREATE SESSION privilege; logon denied


Warning: You are no longer connected to ORACLE.


We need to give create session privilege to user to overcome this issue.

SQL> grant create session to adam;

Grant succeeded.

SQL> conn adam/welcome
Connected.

SQL> show user
USER is "ADAM"

SQL>


Thanks for your patience to view this post........