{"id":5311,"date":"2018-03-17T19:22:46","date_gmt":"2018-03-17T19:22:46","guid":{"rendered":"http:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/"},"modified":"2018-03-17T19:22:46","modified_gmt":"2018-03-17T19:22:46","slug":"use-a-single-users-table-for-multiple-wordpress-sites","status":"publish","type":"post","link":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/","title":{"rendered":"Use a single Users table for multiple WordPress sites"},"content":{"rendered":"<p><iframe loading=\"lazy\" width=\"580\" height=\"380\" src=\"https:\/\/player.vimeo.com\/video\/62042591?color=00adef\" frameborder=\"0\" webkitallowfullscreen mozallowfullscreen allowfullscreen><\/iframe><br \/>Using a single users table for WordPress seems like an easy task at first. You add the CUSTOM_USER_TABLE and CUSTOM_USER_META_TABLE constants to your wp-config.php file and you are apparently off to the races; or are you?  What seems like a simple task becomes more involved when we realize that WordPress doesn&#8217;t handle creating user roles (and permissions) in a graceful way, when we use custom user tables.  So, if you&#8217;re one of the many that are left wondering why you are getting an error message that says: &#8220;You do not have sufficient permissions to access this page,&#8221; this video is for you.  By the end of the video, you should have a better understanding of how WordPress decipher&#8217;s roles and permissions, and what we need to do to help make sure we are getting the final experience that we expect.<br \/><a href=\"https:\/\/1.envato.market\/coderevolution\">Check out these cool WordPress plugins!<\/a> &#8211; CodeRevolution.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Using a single users table for WordPress seems like an easy task at first. You add the CUSTOM_USER_TABLE and CUSTOM_USER_META_TABLE constants to your wp-config.php file and you are apparently off to the races; or are you? What seems like a simple task becomes more involved when we realize that WordPress doesn&#8217;t handle creating user roles&hellip;<\/p>\n","protected":false},"author":1,"featured_media":5312,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1330,1903,1375,1287,313,250,44,1353],"class_list":["post-5311","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wp","tag-and","tag-mike-mclin","tag-screencast","tag-the","tag-tutorial","tag-web-development","tag-wordpress","tag-you"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"WPInitiator\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"WP Initiate | The best website for learning details about WordPress\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Use a single Users table for multiple WordPress sites | WP Initiate\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-03-17T19:22:46+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2018-03-17T19:22:46+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Use a single Users table for multiple WordPress sites | WP Initiate\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#article\",\"name\":\"Use a single Users table for multiple WordPress sites | WP Initiate\",\"headline\":\"Use a single Users table for multiple WordPress sites\",\"author\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/wpinitiate.com\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/5311\\\/431416803_1280x720.jpg\",\"width\":1280,\"height\":720,\"caption\":\"Use a single Users table for multiple WordPress sites\"},\"datePublished\":\"2018-03-17T19:22:46+00:00\",\"dateModified\":\"2018-03-17T19:22:46+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#webpage\"},\"articleSection\":\"WordPress, and, mike mclin, screencast, the, Tutorial, Web Development, WordPress, you, Vimeomatic_0_0\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wpinitiate.com\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/category\\\/wp\\\/#listItem\",\"name\":\"WordPress\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/category\\\/wp\\\/#listItem\",\"position\":2,\"name\":\"WordPress\",\"item\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/category\\\/wp\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#listItem\",\"name\":\"Use a single Users table for multiple WordPress sites\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#listItem\",\"position\":3,\"name\":\"Use a single Users table for multiple WordPress sites\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/category\\\/wp\\\/#listItem\",\"name\":\"WordPress\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/#organization\",\"name\":\"WP Initiate\",\"description\":\"The best website for learning details about WordPress\",\"url\":\"https:\\\/\\\/wpinitiate.com\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/author\\\/admin\\\/#author\",\"url\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/author\\\/admin\\\/\",\"name\":\"WPInitiator\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fa4daefd3362225833901135e9ff40cb644cd3c0d79406f6e5b7f9188f05b2d7?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"WPInitiator\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#webpage\",\"url\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/\",\"name\":\"Use a single Users table for multiple WordPress sites | WP Initiate\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/author\\\/admin\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/wpinitiate.com\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/5311\\\/431416803_1280x720.jpg\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#mainImage\",\"width\":1280,\"height\":720,\"caption\":\"Use a single Users table for multiple WordPress sites\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/index.php\\\/2018\\\/03\\\/17\\\/use-a-single-users-table-for-multiple-wordpress-sites\\\/#mainImage\"},\"datePublished\":\"2018-03-17T19:22:46+00:00\",\"dateModified\":\"2018-03-17T19:22:46+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/#website\",\"url\":\"https:\\\/\\\/wpinitiate.com\\\/\",\"name\":\"WP Initiate\",\"description\":\"The best website for learning details about WordPress\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/wpinitiate.com\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Use a single Users table for multiple WordPress sites | WP Initiate","description":"","canonical_url":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#article","name":"Use a single Users table for multiple WordPress sites | WP Initiate","headline":"Use a single Users table for multiple WordPress sites","author":{"@id":"https:\/\/wpinitiate.com\/index.php\/author\/admin\/#author"},"publisher":{"@id":"https:\/\/wpinitiate.com\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/wpinitiate.com\/wp-content\/uploads\/2018\/03\/5311\/431416803_1280x720.jpg","width":1280,"height":720,"caption":"Use a single Users table for multiple WordPress sites"},"datePublished":"2018-03-17T19:22:46+00:00","dateModified":"2018-03-17T19:22:46+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#webpage"},"isPartOf":{"@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#webpage"},"articleSection":"WordPress, and, mike mclin, screencast, the, Tutorial, Web Development, WordPress, you, Vimeomatic_0_0"},{"@type":"BreadcrumbList","@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/wpinitiate.com\/#listItem","position":1,"name":"Home","item":"https:\/\/wpinitiate.com\/","nextItem":{"@type":"ListItem","@id":"https:\/\/wpinitiate.com\/index.php\/category\/wp\/#listItem","name":"WordPress"}},{"@type":"ListItem","@id":"https:\/\/wpinitiate.com\/index.php\/category\/wp\/#listItem","position":2,"name":"WordPress","item":"https:\/\/wpinitiate.com\/index.php\/category\/wp\/","nextItem":{"@type":"ListItem","@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#listItem","name":"Use a single Users table for multiple WordPress sites"},"previousItem":{"@type":"ListItem","@id":"https:\/\/wpinitiate.com\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#listItem","position":3,"name":"Use a single Users table for multiple WordPress sites","previousItem":{"@type":"ListItem","@id":"https:\/\/wpinitiate.com\/index.php\/category\/wp\/#listItem","name":"WordPress"}}]},{"@type":"Organization","@id":"https:\/\/wpinitiate.com\/#organization","name":"WP Initiate","description":"The best website for learning details about WordPress","url":"https:\/\/wpinitiate.com\/"},{"@type":"Person","@id":"https:\/\/wpinitiate.com\/index.php\/author\/admin\/#author","url":"https:\/\/wpinitiate.com\/index.php\/author\/admin\/","name":"WPInitiator","image":{"@type":"ImageObject","@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/fa4daefd3362225833901135e9ff40cb644cd3c0d79406f6e5b7f9188f05b2d7?s=96&d=mm&r=g","width":96,"height":96,"caption":"WPInitiator"}},{"@type":"WebPage","@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#webpage","url":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/","name":"Use a single Users table for multiple WordPress sites | WP Initiate","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/wpinitiate.com\/#website"},"breadcrumb":{"@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#breadcrumblist"},"author":{"@id":"https:\/\/wpinitiate.com\/index.php\/author\/admin\/#author"},"creator":{"@id":"https:\/\/wpinitiate.com\/index.php\/author\/admin\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/wpinitiate.com\/wp-content\/uploads\/2018\/03\/5311\/431416803_1280x720.jpg","@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#mainImage","width":1280,"height":720,"caption":"Use a single Users table for multiple WordPress sites"},"primaryImageOfPage":{"@id":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/#mainImage"},"datePublished":"2018-03-17T19:22:46+00:00","dateModified":"2018-03-17T19:22:46+00:00"},{"@type":"WebSite","@id":"https:\/\/wpinitiate.com\/#website","url":"https:\/\/wpinitiate.com\/","name":"WP Initiate","description":"The best website for learning details about WordPress","inLanguage":"en-US","publisher":{"@id":"https:\/\/wpinitiate.com\/#organization"}}]},"og:locale":"en_US","og:site_name":"WP Initiate | The best website for learning details about WordPress","og:type":"article","og:title":"Use a single Users table for multiple WordPress sites | WP Initiate","og:url":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/","article:published_time":"2018-03-17T19:22:46+00:00","article:modified_time":"2018-03-17T19:22:46+00:00","twitter:card":"summary","twitter:title":"Use a single Users table for multiple WordPress sites | WP Initiate"},"aioseo_meta_data":{"post_id":"5311","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-01-13 18:00:12","updated":"2025-06-21 04:39:45","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/wpinitiate.com\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/wpinitiate.com\/index.php\/category\/wp\/\" title=\"WordPress\">WordPress<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tUse a single Users table for multiple WordPress sites\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/wpinitiate.com\/"},{"label":"WordPress","link":"https:\/\/wpinitiate.com\/index.php\/category\/wp\/"},{"label":"Use a single Users table for multiple WordPress sites","link":"https:\/\/wpinitiate.com\/index.php\/2018\/03\/17\/use-a-single-users-table-for-multiple-wordpress-sites\/"}],"_links":{"self":[{"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/posts\/5311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/comments?post=5311"}],"version-history":[{"count":0,"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/posts\/5311\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/media\/5312"}],"wp:attachment":[{"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/media?parent=5311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/categories?post=5311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wpinitiate.com\/index.php\/wp-json\/wp\/v2\/tags?post=5311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}