Operations failing due to lack of SQL permissions

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Many issues can be caused by SQL operations failing. Some which we have seen in the past include:

  • Not being able to create projects
  • Not being able to invite users

Something similar to this appears in the atlassian-jira.log:

Caused by: java.sql.SQLException: CREATE TABLE permission denied in database 'JIRA'.

Cause

The SQL user used by JIRA does not have the necessary permissions.

Resolution

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.