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

updated at 

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for Oracle, Navicat Premium

Apply Navicat Version No.: All

ORA-01045-01.png

Solution

  1. Grant CREATE SESSION to the user
  2. Go to User > User
  3. Select the user in the list
  4. Right-click the user and choose Edit User
  5. Under Server Privileges tab, check "CREATE SESSION"
  6. Click Save

ORA-01045-02.png

Have more questions?
Submit Ticket