|
(→Installation w/SQLServer)
|
(→Installation w/SQLServer)
|
| Line 21: | |||
| <br/> | <br/> | ||
| <br/> | <br/> | ||
| + | Be sure to grant a schema for a user (default is '''anthill3''') | ||
| + | <br/> | ||
| + | <br/> | ||
| Make sure you grant all permissions available to the user being used for anthill: <pre>USE DATABASE [databasename] | Make sure you grant all permissions available to the user being used for anthill: <pre>USE DATABASE [databasename] | ||
| GRANT ALL TO [username]</pre> | GRANT ALL TO [username]</pre> | ||
| Line 26: | |||
| <br/> | <br/> | ||
| Also ensure the correct roles are assigned to the database user: | Also ensure the correct roles are assigned to the database user: | ||
| - | * permission1 | + | * [schema] |
| - | * [[Image:sqlserver-permissions.png|left|480x480px|alt=Shows the checkboxes on the user account for the anthill database|Shows the checkboxes on the user account for the anthill database]] | + | * db_accessadmin |
| + | * db_backupoperator | ||
| + | * db_datareader | ||
| + | * db_datawriter | ||
| + | * db_ddladmin | ||
| + | * [[Image:sqlserver-permissions.png|left|320x320px|alt=Shows the checkboxes on the user account for the anthill database|Shows the checkboxes on the user account for the anthill database]] | ||
