How to apply "db_backup_operator" role and "Grant the Alter Database" permission to users creted before Plesk 12

Created:

2016-11-16 12:48:42 UTC

Modified:

2017-04-24 12:11:00 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to apply "db_backup_operator" role and "Grant the Alter Database" permission to users creted before Plesk 12

Applicable to:

  • Plesk 12.0 for Windows

Symptoms

Plesk was upgraded to 12 version. Database server settings "Grant the ALTER DATABASE permission to all Microsoft SQL Server database users" and "Assign db_backup_operator role to users" were changed, however the changes are applied only to newly created users.

How does administrator apply these settings to users that were created before the upgrade?

Resolution

Plesk 12 provides the following command line option for 'mssqlmng' utility that apply users settings as per the options configured in Plesk:

"%plesk_cli%\\repair.exe" --update-mssql-users-permissions
Have more questions? Submit a request
Please sign in to leave a comment.