You can follow below steps to provide db_owner permission to user:
- Login to server via RDP.
- Click on Run and then enter “%plesk_dir%admin\conf\”.
- Now your panel.ini file will be open and you have to add below lines in that file.
Code:
[databaseManagement]
features.roles.mssql.readWrite =
db_owner,db_datareader,db_datawriter,db_backupoperator,db_ddladmin- At last run below command, so that you can apply changes in MSSQL database.
Code:
"%plesk_cli%\repair.exe" --update-mssql-users-permissions