How To Add Db_owner Role To Newly Created Users? - AccuWebHosting

• Products
  • Linux Shared Hosting
  • Windows VPS Plans
  • Linux VPS Plans
  • Windows Shared Hosting
  • AntiSpam Solution
  • Reseller Hosting Plans
  • Add-On Services
  • Windows Cloud Hosting
  • Linux Cloud Hosting
  • Public Cloud Hosting
  • WordPress Hosting
  • WooCommerce Hosting
  • Virtual Desktop
  • Email Hosting
  • WordPress Cloud
• Domains
  • Register a New Domain
  • Transfer Domains to Us
  • -----
  • Domain Pricing
• Support
  • Contact Us
  • -----
  • Network Status
  • Knowledgebase
  • News
• Login

How to add db_owner role to newly created users?

1. Portal Home
2. Knowledgebase
3. Database Server
4. MSSQL Server
5. How to add db_owner role to newly created users?

Categories

50 Affiliate Questions 47 Billing & Accounts 40 Client Area Tutorials 27 Cloud Hosting 792 Control Panels 118 Database Server 14 Dedicated Servers 3 Email Verification 3 Form Downloads 225 Mail Servers Tutorials 246 Miscellaneous Articles 613 Pre-Sales Questions 1 Video Tutorials 819 VPS Hosting 190 Web Hosting 112 Web Services 11 Website Migration 243 WordPress Hosting

Support

My Support Tickets Announcements Knowledgebase Downloads Network Status Open Ticket

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 Get Windows VPS

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.

Get Windows VPS Was this answer helpful? 1 Users Found This Useful (2 Votes) Yes No

Most Popular Articles

Operation must use an updateable query Microsoft OLE DB Provider for ODBC Drivers error '80004005' .[Microsoft] [ODBC Microsoft Access Driver]

This error usually occurs when you try to insert or update data in MS Access database i.e. you do...

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...

Microsoft SQL Server 2016 Recommendation

The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the...

Where is the database folder for MS-Access database?

'db' folder created along with the 'www' or 'wwwroot' folder is the recommended folder for .mdb...

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of the database in MS SQL...

ShareTweetShareShareShare Submit Close

Generate Password

Please enter a number between 8 and 64 for the password length Password Length Generated Password Generate new password Copy Close Copy to clipboard and Insert