After migration to Plesk 12, db_owner role is disabled

Created:

2016-11-16 12:44:09 UTC

Modified:

2017-08-16 16:44:01 UTC

0

Was this article helpful?


Have more questions?

Submit a request

After migration to Plesk 12, db_owner role is disabled

Applicable to:

  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

After migration to Plesk 12, the access rights to databases have changed: a newly created user does not have db_owner role enabled.

Cause

Since Plesk version 12 MSSQL users created through Plesk interface are not provided with db_owner role for security reasons.

Resolution

Use either of the following methods to resolve the issue:

  1. Go to Tools & Settings > Database Servers > Settings and enable Grant the ALTER DATABASE permission to all Microsoft SQL Server database users option.

  2. CLI command:

    %plesk_dir%\\bin\\server_pref.exe --update -grant-alter-database-to-mssql-users true

Note: to fix permissions and roles of all MS SQL users, run the following command:

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