{"id":15014,"date":"2022-10-10T02:19:01","date_gmt":"2022-10-09T20:49:01","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/"},"modified":"2022-10-10T02:19:01","modified_gmt":"2022-10-09T20:49:01","slug":"solved-all-privileges-except-one-table-in-mysql-duplicate","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/","title":{"rendered":"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-24204787\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"24204787\" data-parentid=\"24204504\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<blockquote>\n<p>or is there another way to grant ALL PRIVILEGES and REVOKE the special<br \/>\n  one?<\/p>\n<\/blockquote>\n<p>NO, there is not any shortcut to do this. You will have to revoke <code>ALL PRIVILEGE<\/code> from user and then <code>GRANT<\/code> for each table separately.<\/p>\n<pre><code>REVOKE ALL PRIVILEGES ON db.* FROM 'carl'@'%'; \n<\/code><\/pre>\n<p>Though there is option for automating this task of <code>GRANTING<\/code> all tables separately using scripting like:<\/p>\n<p>Pseudo code<\/p>\n<pre><code>1. You can list out all tables using `SHOW TABLES;`\n\n2. for each item is on table list\n\n3. if(item != \"specific table name\") then\n   GRANT table privilege to user\n<\/code><\/pre>\n<p>See this similar post MySQL grant all privileges to database except one table<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved ALL PRIVILEGES except one table in MySQL [duplicate] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] or is there another way to grant ALL PRIVILEGES and REVOKE the special one? NO, there is not any shortcut to do this. You will have to revoke ALL PRIVILEGE from user and then GRANT for each table separately. REVOKE ALL PRIVILEGES ON db.* FROM &#8216;carl&#8217;@&#8217;%&#8217;; Though there is option for automating this task &#8230; <a title=\"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/\" aria-label=\"More on [Solved] ALL PRIVILEGES except one table in MySQL [duplicate]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340,3901],"class_list":["post-15014","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-privileges"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] ALL PRIVILEGES except one table in MySQL [duplicate] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] or is there another way to grant ALL PRIVILEGES and REVOKE the special one? NO, there is not any shortcut to do this. You will have to revoke ALL PRIVILEGE from user and then GRANT for each table separately. REVOKE ALL PRIVILEGES ON db.* FROM &#039;carl&#039;@&#039;%&#039;; Though there is option for automating this task ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-09T20:49:01+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate]\",\"datePublished\":\"2022-10-09T20:49:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/\"},\"wordCount\":86,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"privileges\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/\",\"name\":\"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-09T20:49:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate] - JassWeb","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:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate] - JassWeb","og_description":"[ad_1] or is there another way to grant ALL PRIVILEGES and REVOKE the special one? NO, there is not any shortcut to do this. You will have to revoke ALL PRIVILEGE from user and then GRANT for each table separately. REVOKE ALL PRIVILEGES ON db.* FROM 'carl'@'%'; Though there is option for automating this task ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/","og_site_name":"JassWeb","article_published_time":"2022-10-09T20:49:01+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate]","datePublished":"2022-10-09T20:49:01+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/"},"wordCount":86,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","privileges"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/","url":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/","name":"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-09T20:49:01+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-all-privileges-except-one-table-in-mysql-duplicate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] ALL PRIVILEGES except one table in MySQL [duplicate]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=15014"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15014\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=15014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=15014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=15014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}