ORA-01045: user lacks CREATE SESSION privilege; logon denied while creating user in database

This document describes about "ORA-01045" issue.

Issue:

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

Warning: You are no longer connected to ORACLE.

Cause and Solution:

User CHRIS does have "CREATE SESSION" privilege to connect database.

connect to database as sys and grant "CREATE SESSION" privilege to CHRIS.

SQL> conn sys as sysdba

Enter password: 

Connected.

SQL> show user

USER is "SYS"

SQL> grant create session to chris;

Grant succeeded.

Validation:

SQL> conn chris/welcome

Connected.

SQL> show user

USER is "CHRIS"

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