Thursday, May 31, 2012

ORA-01045:user name lacks CREATE SESSION privilege; logon denied

The Solution For this Error Is Simple :

sqlplus / as sysdba
grant create session to "USER-NAME";

Done


Thank you
Osama Mustafa

7 comments:

  1. Replies
    1. What you mean by Instance ! I talk here about Schema , and if you mean it you can't connect to it if you don't grant create session priv. and to grant it you should have SYSDBA role .

      Delete