How to add db_owner role to newly created users?

From Plesk version 12, MSSSQL users created from the Plesk panel will not have the db_owner permission due to some security reasons. Please refer to the following steps to provide db_owner permission to the database user. 

  1. Log in to your server via RDP. Please refer to how to connect my server?

  2. Open the Run and enter the %plesk_dir%admin\conf\ and click on the OK button. 

  3. Open the panel.ini file and add the below lines. If the panel.ini doesn't exist, please rename panel.ini.sample to panel.ini.

    [databaseManagement]
    features.roles.mssql.readWrite =
    db_owner,db_datareader,db_datawriter,db_backupoperator,db_ddladmin
  4. Finally, run the below command to apply the changes in the MSSQL database.

    "%plesk_cli%\repair.exe" --update-mssql-users-permissions

How to assign db_owner permission via Microsoft SQL Management Studio.

  1. Open SQL Management studio.

  2. Go to the security and logins.

  3. Right-click on your database and click on the properties.

  4. Inside the properties, go to the user mapping.

  5. Go to the DB user and check the db_owner and public field.

Related Articles

Choosing Between SQL Server 2012 and SQL Server 2014

If you are running SQL Server 2008 R2, you might be looking to upgrade your SQL server to...

How to install SQL Server Reporting Service (SSRS) on MSSQL 2014 Express Edition?

SQL Server Reporting Services is used for creating, publishing, and managing reports, and...

How to change password for MS SQL admin user?

Following tutorial will guide you to reset the MS SQL server sa user password. We assume that you...

How to assign particular permissions to SQL server database user from SQL Server Management Studio?

We can restrict SQL database users to fire some critical queries, e.g. Update, Delete, etc....

How to Backup MSSQL Database from SQL Server Management Studio?

To take MS SQL database backup, first you need to connect to MS SQL Server through SQL Server...

  • 0 Users Found This Useful

Was this answer helpful?