Operations failing due to lack of SQL permissions
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
- Shut down JIRA
Update the permissions for the user in SQL per:
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.