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

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

Post a Comment

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET