Wednesday 21 September 2016

ORA-01045: user lacks CREATE SESSION privilege logon denied?

SQL> select username from dba_users;

USERNAME
------------------------------
OUTLN
SYS
SYSTEM
DIP
ORACLE_OCM
APPQOSSYS
DBSNMP

7 rows selected.

SQL> create user u1 identified by u1;

User created.

SQL> select username from dba_users;

USERNAME
------------------------------
OUTLN
U1
SYS
SYSTEM
DIP
ORACLE_OCM
APPQOSSYS
DBSNMP

8 rows selected.

SQL> conn u1/u1;
ERROR:
ORA-01045: user U1 lacks CREATE SESSION privilege; logon denied


Warning: You are no longer connected to ORACLE.
SQL> grant connect,resource to u1;
Grant succeeded.

SQL> conn u1/u1;
Connected.


No comments:

Post a Comment