{"id":7117,"date":"2019-02-28T13:38:06","date_gmt":"2019-02-28T13:38:06","guid":{"rendered":"https:\/\/www.siliconhouse.net\/support\/?page_id=7117"},"modified":"2019-02-28T13:38:08","modified_gmt":"2019-02-28T13:38:08","slug":"how-to-view-database-user-roles-in-windows-reseller-hosting","status":"publish","type":"page","link":"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/","title":{"rendered":"How to view database user roles and permissions?"},"content":{"rendered":"\n

Windows Reseller Web Hosting<\/a>\u00a0comes with Plesk Control Panel.\u00a0 Plesk control panel provides user roles and permissions for MySQL and Microsoft SQL Server database users. The roles act as templates that help to assign permissions to a database user. The following database user roles are supported: Read and Write (used by default), Read Only, and Write Only. Each role has a pre-defined set of privileges that are granted to a database user account with this role. You can edit sets of privileges that correspond to different roles.<\/p>\n\n\n\n

Kindly follow the below procedure to check the Permission for database user :<\/p>\n\n\n\n

[1] Login to plesk control panel<\/p>\n\n\n\n

[2] Click on subscriptions<\/p>\n\n\n\n

[3] Click on subscriptions name<\/p>\n\n\n\n

[4] Click on databases<\/p>\n\n\n\n

[5] Click on user management<\/p>\n\n\n\n

[6] Click on the user<\/p>\n\n\n\n

[7] There you can able to view the permission for the database user.<\/p>\n","protected":false},"excerpt":{"rendered":"

Windows Reseller Web Hosting\u00a0comes with Plesk Control Panel.\u00a0 Plesk control panel provides user roles and permissions for MySQL and Microsoft<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-7117","page","type-page","status-publish","hentry"],"yoast_head":"\nHow to view database user roles and permissions for databases<\/title>\n<meta name=\"description\" content=\"In Plesk control panel with MySQL and MSSQL database, users can select roles and permissions for database users in windows reseller web hosting.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to view database user roles and permissions for databases\" \/>\n<meta property=\"og:description\" content=\"In Plesk control panel with MySQL and MSSQL database, users can select roles and permissions for database users in windows reseller web hosting.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/\" \/>\n<meta property=\"og:site_name\" content=\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/siliconhouse.net\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-28T13:38:08+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@siliconhouse\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/\",\"name\":\"How to view database user roles and permissions for databases\",\"isPartOf\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#website\"},\"datePublished\":\"2019-02-28T13:38:06+00:00\",\"dateModified\":\"2019-02-28T13:38:08+00:00\",\"description\":\"In Plesk control panel with MySQL and MSSQL database, users can select roles and permissions for database users in windows reseller web hosting.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.siliconhouse.net\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to view database user roles and permissions?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#website\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/\",\"name\":\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\",\"description\":\"Reseller Hosting - Dedicated Servers - Cloud\",\"publisher\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.siliconhouse.net\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#organization\",\"name\":\"Silicon House\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png\",\"contentUrl\":\"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png\",\"width\":42,\"height\":40,\"caption\":\"Silicon House\"},\"image\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/siliconhouse.net\",\"https:\/\/x.com\/siliconhouse\",\"https:\/\/www.youtube.com\/siliconhouse\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to view database user roles and permissions for databases","description":"In Plesk control panel with MySQL and MSSQL database, users can select roles and permissions for database users in windows reseller web hosting.","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:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/","og_locale":"en_US","og_type":"article","og_title":"How to view database user roles and permissions for databases","og_description":"In Plesk control panel with MySQL and MSSQL database, users can select roles and permissions for database users in windows reseller web hosting.","og_url":"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/","og_site_name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","article_publisher":"https:\/\/www.facebook.com\/siliconhouse.net","article_modified_time":"2019-02-28T13:38:08+00:00","twitter_card":"summary_large_image","twitter_site":"@siliconhouse","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/","url":"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/","name":"How to view database user roles and permissions for databases","isPartOf":{"@id":"https:\/\/www.siliconhouse.net\/support\/#website"},"datePublished":"2019-02-28T13:38:06+00:00","dateModified":"2019-02-28T13:38:08+00:00","description":"In Plesk control panel with MySQL and MSSQL database, users can select roles and permissions for database users in windows reseller web hosting.","breadcrumb":{"@id":"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.siliconhouse.net\/support\/how-to-view-database-user-roles-in-windows-reseller-hosting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.siliconhouse.net\/support\/"},{"@type":"ListItem","position":2,"name":"How to view database user roles and permissions?"}]},{"@type":"WebSite","@id":"https:\/\/www.siliconhouse.net\/support\/#website","url":"https:\/\/www.siliconhouse.net\/support\/","name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","description":"Reseller Hosting - Dedicated Servers - Cloud","publisher":{"@id":"https:\/\/www.siliconhouse.net\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.siliconhouse.net\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.siliconhouse.net\/support\/#organization","name":"Silicon House","url":"https:\/\/www.siliconhouse.net\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","contentUrl":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","width":42,"height":40,"caption":"Silicon House"},"image":{"@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/siliconhouse.net","https:\/\/x.com\/siliconhouse","https:\/\/www.youtube.com\/siliconhouse"]}]}},"_links":{"self":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/7117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/comments?post=7117"}],"version-history":[{"count":1,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/7117\/revisions"}],"predecessor-version":[{"id":7118,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/7117\/revisions\/7118"}],"wp:attachment":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/media?parent=7117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}