Home » ORA-01045 CREATE SESSION privilege logon denied

ORA-01045 CREATE SESSION privilege logon denied

by tuanlp

 

🚚 When trying to connect to an Oracle database, you might run into this error:

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

The reason is that the username you are using to connect lacks the CREATE SESSION system privilege.

So to fix it, you need to grant the permission:

GRANT CREATE SESSION TO user_name;

You may also like