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

WebLogic(12c) 12.1.2.0.0 Install in Silent Mode - Linux

Tuxedo Rolling Patch Apply 12.1.1.0_RP077 in Linux