ORA-01045 CREATE SESSION privilege logon denied

 

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

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log