How to add db_owner role to newly created users

Created:

2017-06-09 18:03:18 UTC

Modified:

2017-08-08 13:21:21 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to add db_owner role to newly created users

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:

  1. 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
  2. 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.

Have more questions? Submit a request
Please sign in to leave a comment.