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

SQL Access Manager: File: SQL Access ManagerSQL error. Stmt #: 2  Error Position: 0  Return: 8097 - Oracle initialization error

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;

Comments

Popular posts from this blog

PeopleTools 8.56 and Tuxedo 12.2.2 Error

Tuxedo Rolling Patch Apply 12.1.1.0_RP077 in Linux