Problem Definition

In our Database Setup for SQL Server documentation, step 2 item 5 is a bit unclear:

Give this user full create, read and write permissions for the database tables. Confluence must be able to create its own schema. Refer to the SQL Server documentation for how to do this.

For many users this is done by adding the user to the db_owner role.

A lot of users may not be aware of this, and thus will run into permissions issues. I've personally seen this in many support tickets and on Community.

Suggested Solution

Clarify in the documentation that in many cases it can be accomplished by adding the user to the db_owner role