✦

Technology Geek

18+ YEARS AMONG THE CLOUDS

✦ TRANSMISSION

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 responses to “ORA-01045:user name lacks CREATE SESSION privilege; logon denied”

  1. shab

    Thanks.

    Like

    Reply
  2. Osama Mustafa

    Welcome

    Like

    Reply
  3. Ghassane maarouf

    how to connect to an instance ?

    Like

    Reply
  4. Osama Mustafa

    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 .

    Like

    Reply
  5. Narasimha Vemisetty

    Thanks alot

    Like

    Reply
  6. Anonymous

    Thanks 😀

    Like

    Reply
  7. Osama Mustafa

    Welcome

    Like

    Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.