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;
AND