Question
How to add db_owner role to newly created MSSQL users?
Answer
Starting from Plesk version 12, MSSQL users created through Plesk interface are not provided with db_owner role for security reasons.
In order to change this behavior perform the following steps:
-
Add the following settings to the
%plesk_dir%\admin\conf\panel.ini:[databaseManagement]
features.roles.mssql.readWrite = db_owner,db_datareader,db_datawriter,db_backupoperator,db_ddladmin -
Run the following command to apply the changes to all the MSSQL servers:
"%plesk_cli%\repair.exe" --update-mssql-users-permissions
Note: the existing users will obtain a new role as well.
Additionally: refer to the documentation Database User Roles and Permissions for more details.
Comments
0 comments
Please sign in to leave a comment.