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

This error is thrown if a user wants to log on a database but lacks the create session system privilege.

In order to give someone this privilege, use:

grant create session to the_user;

See also other Oracle errors.