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:

Replace “USER-NAME” with the message’s user name.

 

source:http://osamamustafa.blogspot.gr/2012/05/ora-01045user-name-lacks-create-session.html