|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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.