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

Apply OS: Windows, Mac, Linux

Apply Navicat Product: Navicat for Oracle, Navicat Premium

Apply Navicat Version No.: All

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

Have more questions? Submit Ticket.
Have more questions? Submit a request

0 Comments

Article is closed for comments.