- Plesk for Windows
How to provide
permission for MSSQL database users?
According to the documentation
Database User Roles and Permissions
, Plesk provides three types of roles for MSSQL database users in Plesk:
Read and Write
, and each one has its own number of MSSQL roles.
permission requires a membership in the
fixed database role.
In order to add
permission for database users perform the following steps:
db_securityadminfixed database role to the one of the role (e.g.
readWrite) by adding the following in
features.roles.mssql.readWrite = db_securityadmin,db_datareader,db_datawriter,db_backupoperator,db_ddladmin
Run the following command to apply the changes to all the MSSQL servers:
C:\> "%plesk_cli%\repair.exe" --update-mssql-users-permissions
Note: the existing users will obtain a new role as well.
Additionally: refer to the Microsoft CREATE ROLE documentation for more details.