If you get this message/error in Oracle:
ORA-01045:user name lacks CREATE SESSION privilege; logon denied
The Solution is simple. Just open command prompt and type the following:
1 2 |
sqlplus / as sysdba grant create session to "USER-NAME"; |
Replace “USER-NAME” with the message’s user name.
source:http://osamamustafa.blogspot.gr/2012/05/ora-01045user-name-lacks-create-session.html