After migration to Plesk 12, db_owner role is disabled

Refers to:

  • Plesk
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Created:

2016-11-16 12:44:09 UTC

Modified:

2016-12-21 19:05:35 UTC

0

Was this article helpful?


Have more questions?

Submit a request

After migration to Plesk 12, db_owner role is disabled

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.