Error 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;
And you should be able to login to your database by now.
Need a good GUI tool for databases? TablePlus provides a native client that allows you to access and manage Oracle, MySQL, SQL Server, PostgreSQL, and many other databases simultaneously using an intuitive and powerful graphical interface.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS
