{"id":24376,"date":"2022-02-02T14:32:26","date_gmt":"2022-02-02T14:32:26","guid":{"rendered":"https:\/\/1-grid.com\/knowledge\/database-user-permissions-in-windows-plesk\/"},"modified":"2023-03-27T11:23:13","modified_gmt":"2023-03-27T11:23:13","slug":"database-user-permissions-in-windows-plesk","status":"publish","type":"ht_kb","link":"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/","title":{"rendered":"Database User Permissions in Windows Plesk"},"content":{"rendered":"
\n

If you use MySQL or Microsoft SQL Server, you can manage permissions for database users through the Plesk UI, such as the permissions to perform operations on table structure and data.\u00a0<\/span><\/p>\n

\n

For MySQL these permissions are Select, Insert, Create, Drop and so on, and for Microsoft SQL Server these permissions are database-level roles such as db_ddladmin, db_datawriter, and so on.<\/span><\/p>\n

\n

To help you assign permissions, Plesk uses templates of permission sets called roles. On creation, each database user account is granted the default set of permissions. This set of permissions corresponds to the Read and Write<\/strong> role.\u00a0<\/span><\/p>\n

\n

Other supported roles are Read Only<\/strong> and Write Only<\/strong>. In addition, MySQL allows the Custom<\/strong> role with user-defined sets of privileges.<\/span><\/p>\n

\n

To modify the permissions of a MySQL database user:<\/span><\/p>\n

\n

1.\u00a0 \u00a0<\/span><\/span><\/span>Go to Websites & Domains<\/strong> > Databases<\/strong> > User Management<\/strong> and click the database user name.<\/span><\/span><\/p>\n

By default, newly created database users have the Read and Write<\/strong> role. You can view and change the privileges included in this role.<\/span><\/p>\n

2.\u00a0 \u00a0<\/span><\/span><\/span>To allow read access or write access only, select the corresponding role (Read Only<\/strong> or Write Only<\/strong>).<\/span><\/span><\/p>\n

3.\u00a0 \u00a0<\/span><\/span><\/span>To add or remove privileges from the role already selected for the user, select or clear the corresponding checkboxes (Select<\/strong>, Insert<\/strong>, Update<\/strong>, and so on).<\/span><\/span><\/p>\n

Note that if you modify the set of privileges, the role becomes Custom<\/strong>.<\/span><\/p>\n

\n

To modify the permissions of a SQL Server database user:<\/span><\/p>\n

\n

1.\u00a0 \u00a0<\/span><\/span><\/span>Go to Websites & Domains<\/strong> > Databases<\/strong> > User Management<\/strong> and click the database user name.<\/span><\/span><\/p>\n

By default, newly created database users have the Read and Write<\/strong> role.<\/span><\/p>\n

2.\u00a0 \u00a0<\/span><\/span><\/span>To allow read access or write access only, select the corresponding role (Read Only<\/strong> or Write Only<\/strong>).<\/span><\/span><\/p>\n

The default sets of permissions on Microsoft SQL Server are the following:<\/span><\/p>\n

\n

\n\n\n\n\n\n\n\n\n
\n

Permission<\/span><\/strong><\/p>\n<\/td>\n

\n

Read and Write<\/span><\/strong><\/p>\n<\/td>\n

\n

Read Only<\/span><\/strong><\/p>\n<\/td>\n

\n

Write Only<\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n<\/thead>\n

\n

db_backupoperator<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

db_datareader<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n

\n

\u2796<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

db_datawriter<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n

\n

\u2796<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

db_ddladmin<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n

\n

\u2796<\/span><\/p>\n<\/td>\n

\n

\u2795<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n

Automatic Changes in User Roles<\/span><\/strong><\/span><\/p>\n

\n

The hosting provider can add or remove permissions that are granted with different roles.<\/span><\/p>\n

\n

On MySQL, these modifications do not affect permissions of existing database users. The only thing that changes is their role in Plesk \u2013 it will change to Custom<\/strong> because their permissions no longer correspond to their previous role (Read and Write<\/strong>, Read Only<\/strong>, or Write Only<\/strong>).\u00a0<\/span><\/p>\n

\n

On Microsoft SQL Server, permissions (database-level roles) of existing users are changed in accordance with the changes made by the hosting provider.<\/span><\/p>\n

\n

The hosting provider can permanently deny some permissions for all MySQL database users, for example, the permission to delete objects. In this case, this permission is not displayed in Plesk.\u00a0<\/span><\/p>\n

\n

On Microsoft SQL Server, if the permission is excluded from all Plesk roles, it is denied for all users.<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

If you use MySQL or Microsoft SQL Server, you can manage permissions for database users through the Plesk UI, such as the permissions to perform operations on table structure and data.\u00a0 For MySQL these permissions are Select, Insert, Create, Drop and so on, and for Microsoft SQL Server these permissions…<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[1199],"ht-kb-tag":[270,470,733,1218,747,1081,1138],"class_list":["post-24376","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-plesk","ht_kb_tag-database","ht_kb_tag-hosting","ht_kb_tag-permission","ht_kb_tag-permissions","ht_kb_tag-plesk","ht_kb_tag-user","ht_kb_tag-windows"],"yoast_head":"\nDatabase User Permissions in Windows Plesk -<\/title>\n<meta name=\"description\" content=\"Database User Permissions in Windows Plesk 1-grid Knowledge Base Database User Permissions in Windows Plesk 1-grid Knowledge Base\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database User Permissions in Windows Plesk -\" \/>\n<meta property=\"og:description\" content=\"Database User Permissions in Windows Plesk 1-grid Knowledge Base Database User Permissions in Windows Plesk 1-grid Knowledge Base\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/\" \/>\n<meta property=\"og:site_name\" content=\"1-grid Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/1grid.co.za\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-27T11:23:13+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@1grid_hosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/\",\"name\":\"Database User Permissions in Windows Plesk -\",\"isPartOf\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\"},\"datePublished\":\"2022-02-02T14:32:26+00:00\",\"dateModified\":\"2023-03-27T11:23:13+00:00\",\"description\":\"Database User Permissions in Windows Plesk 1-grid Knowledge Base Database User Permissions in Windows Plesk 1-grid Knowledge Base\",\"breadcrumb\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1grid.co.za\/knowledge\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database User Permissions in Windows Plesk\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"contentUrl\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"width\":100,\"height\":100,\"caption\":\"1-Grid Domain Hosting Knowledge Base\"},\"image\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/1grid.co.za\/\",\"https:\/\/twitter.com\/1grid_hosting\",\"https:\/\/www.instagram.com\/1grid_hosting\/\",\"https:\/\/za.linkedin.com\/company\/1-grid\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database User Permissions in Windows Plesk -","description":"Database User Permissions in Windows Plesk 1-grid Knowledge Base Database User Permissions in Windows Plesk 1-grid Knowledge Base","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/","og_locale":"en_US","og_type":"article","og_title":"Database User Permissions in Windows Plesk -","og_description":"Database User Permissions in Windows Plesk 1-grid Knowledge Base Database User Permissions in Windows Plesk 1-grid Knowledge Base","og_url":"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/","og_site_name":"1-grid Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/1grid.co.za\/","article_modified_time":"2023-03-27T11:23:13+00:00","twitter_card":"summary_large_image","twitter_site":"@1grid_hosting","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/","url":"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/","name":"Database User Permissions in Windows Plesk -","isPartOf":{"@id":"https:\/\/1grid.co.za\/knowledge\/#website"},"datePublished":"2022-02-02T14:32:26+00:00","dateModified":"2023-03-27T11:23:13+00:00","description":"Database User Permissions in Windows Plesk 1-grid Knowledge Base Database User Permissions in Windows Plesk 1-grid Knowledge Base","breadcrumb":{"@id":"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1grid.co.za\/knowledge\/database-user-permissions-in-windows-plesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1grid.co.za\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Database User Permissions in Windows Plesk"}]},{"@type":"WebSite","@id":"https:\/\/1grid.co.za\/knowledge\/#website","url":"https:\/\/1grid.co.za\/knowledge\/","name":"1-Grid Domain Hosting Knowledge Base","description":"","publisher":{"@id":"https:\/\/1grid.co.za\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/1grid.co.za\/knowledge\/#organization","name":"1-Grid Domain Hosting Knowledge Base","url":"https:\/\/1grid.co.za\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","contentUrl":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","width":100,"height":100,"caption":"1-Grid Domain Hosting Knowledge Base"},"image":{"@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/1grid.co.za\/","https:\/\/twitter.com\/1grid_hosting","https:\/\/www.instagram.com\/1grid_hosting\/","https:\/\/za.linkedin.com\/company\/1-grid"]}]}},"_links":{"self":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/comments?post=24376"}],"version-history":[{"count":5,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24376\/revisions"}],"predecessor-version":[{"id":32386,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24376\/revisions\/32386"}],"wp:attachment":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/media?parent=24376"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-category?post=24376"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-tag?post=24376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}