{"id":4254,"date":"2019-07-10T11:18:37","date_gmt":"2019-07-10T11:18:37","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=4254"},"modified":"2019-07-10T11:18:37","modified_gmt":"2019-07-10T11:18:37","slug":"worksiteimanage-sql-to-change-the-owner-of-workspace-folder","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder","title":{"rendered":"Worksite\\iManage &#8211; SQL to change the owner of Workspace\/Folder"},"content":{"rendered":"<p>Here are the steps to change the owner of Workspace\/Folder in Worksite 10<br \/><br \/>&#8211;To change the owner of a Workspace\/Folder, first we need to find the prj_id of the Workspace\/Folder\u00a0<br \/><br \/>select * where prj_name LIKE &#8216;%FOLDER\\WORKSPACE_NAME%&#8217;<br \/><br \/>&#8211;To change it to a different owner&#8230;<br \/><br \/>update mhgroup.projects set prj_owner = &#8216;NEW_USERID&#8217; where prj_id = &#8216;WORKSPACE_ID&#8217;<br \/><br \/>After changing the owner of the workspace, the author in the docmaster table for this workspace needs to change as well. The owner is still shown as the old one, but after updating the author, the new owner should appear on the workspace profile.<br \/><br \/>Please run the following additional query:<br \/><br \/>&#8211; update mhgroup.docmaster set author =&#8217;new userID&#8217; where docnum = &#8216;you can get this from the query below &#8216;<br \/><br \/>&#8211;also, to change the underlying Workspace\/Folder document&#8217;s owner update mhgroup.docmaster set operator = &#8216;NEW_USERID&#8217;, author = &#8216;NEW_USERID&#8217; where docnum = &#8216;DOCNUM&#8217;<br \/><br \/><b>Please test this against a backup copy of the database. Also make sure you backup the database before running this against production database.<\/b><br \/><br \/>To find the docnum of a workspace: select * from mhgroup.projects where prj_name = &#8216;Exact Name of Workspace&#8217; and subtype = &#8216;work&#8217;<\/p>","protected":false},"excerpt":{"rendered":"<p>Here are the steps to change the owner of Workspace\/Folder in Worksite 10&#8211;To change the owner of a Workspace\/Folder, first we need to find the prj_id of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1066,840,622,3032,3031,591,623,1817],"class_list":["post-4254","post","type-post","status-publish","format-standard","hentry","category-research","tag-change","tag-folder","tag-imanage","tag-not-changing","tag-owner","tag-sql","tag-worksite","tag-workspace"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Here are the steps to change the owner of Workspace\/Folder in Worksite 10--To change the owner of a Workspace\/Folder, first we need to find the prj_id of the Workspace\/Folder select * where prj_name LIKE &#039;%FOLDER\\WORKSPACE_NAME%&#039;--To change it to a different owner...update mhgroup.projects set prj_owner = &#039;NEW_USERID&#039; where prj_id = &#039;WORKSPACE_ID&#039;After changing the owner of the workspace,\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"paris\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Welcome to Pariswells.com |\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Worksite\\iManage \u2013 SQL to change the owner of Workspace\/Folder | Welcome to Pariswells.com\" \/>\n\t\t<meta property=\"og:description\" content=\"Here are the steps to change the owner of Workspace\/Folder in Worksite 10--To change the owner of a Workspace\/Folder, first we need to find the prj_id of the Workspace\/Folder select * where prj_name LIKE &#039;%FOLDER\\WORKSPACE_NAME%&#039;--To change it to a different owner...update mhgroup.projects set prj_owner = &#039;NEW_USERID&#039; where prj_id = &#039;WORKSPACE_ID&#039;After changing the owner of the workspace,\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-07-10T11:18:37+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-07-10T11:18:37+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Worksite\\iManage \u2013 SQL to change the owner of Workspace\/Folder | Welcome to Pariswells.com\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Here are the steps to change the owner of Workspace\/Folder in Worksite 10--To change the owner of a Workspace\/Folder, first we need to find the prj_id of the Workspace\/Folder select * where prj_name LIKE &#039;%FOLDER\\WORKSPACE_NAME%&#039;--To change it to a different owner...update mhgroup.projects set prj_owner = &#039;NEW_USERID&#039; where prj_id = &#039;WORKSPACE_ID&#039;After changing the owner of the workspace,\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#article\",\"name\":\"Worksite\\\\iManage \\u2013 SQL to change the owner of Workspace\\\/Folder | Welcome to Pariswells.com\",\"headline\":\"Worksite\\\\iManage &#8211; SQL to change the owner of Workspace\\\/Folder\",\"author\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\"},\"datePublished\":\"2019-07-10T11:18:37+00:00\",\"dateModified\":\"2019-07-10T11:18:37+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#webpage\"},\"articleSection\":\"Research, change, Folder, imanage, not changing, owner, SQL, worksite, workspace\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pariswells.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"name\":\"Research\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"position\":2,\"name\":\"Research\",\"item\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#listItem\",\"name\":\"Worksite\\\\iManage &#8211; SQL to change the owner of Workspace\\\/Folder\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#listItem\",\"position\":3,\"name\":\"Worksite\\\\iManage &#8211; SQL to change the owner of Workspace\\\/Folder\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"name\":\"Research\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\",\"name\":\"Welcome to Pariswells.com\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris\",\"name\":\"paris\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/93b8ee3f592ac401167f870452bd82d43de80152cd3524e2853403658ada9984?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"paris\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#webpage\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder\",\"name\":\"Worksite\\\\iManage \\u2013 SQL to change the owner of Workspace\\\/Folder | Welcome to Pariswells.com\",\"description\":\"Here are the steps to change the owner of Workspace\\\/Folder in Worksite 10--To change the owner of a Workspace\\\/Folder, first we need to find the prj_id of the Workspace\\\/Folder select * where prj_name LIKE '%FOLDER\\\\WORKSPACE_NAME%'--To change it to a different owner...update mhgroup.projects set prj_owner = 'NEW_USERID' where prj_id = 'WORKSPACE_ID'After changing the owner of the workspace,\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"datePublished\":\"2019-07-10T11:18:37+00:00\",\"dateModified\":\"2019-07-10T11:18:37+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/\",\"name\":\"Welcome to Pariswells.com\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Worksite\\iManage \u2013 SQL to change the owner of Workspace\/Folder | Welcome to Pariswells.com","description":"Here are the steps to change the owner of Workspace\/Folder in Worksite 10--To change the owner of a Workspace\/Folder, first we need to find the prj_id of the Workspace\/Folder select * where prj_name LIKE '%FOLDER\\WORKSPACE_NAME%'--To change it to a different owner...update mhgroup.projects set prj_owner = 'NEW_USERID' where prj_id = 'WORKSPACE_ID'After changing the owner of the workspace,","canonical_url":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#article","name":"Worksite\\iManage \u2013 SQL to change the owner of Workspace\/Folder | Welcome to Pariswells.com","headline":"Worksite\\iManage &#8211; SQL to change the owner of Workspace\/Folder","author":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"publisher":{"@id":"https:\/\/pariswells.com\/blog\/#organization"},"datePublished":"2019-07-10T11:18:37+00:00","dateModified":"2019-07-10T11:18:37+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#webpage"},"isPartOf":{"@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#webpage"},"articleSection":"Research, change, Folder, imanage, not changing, owner, SQL, worksite, workspace"},{"@type":"BreadcrumbList","@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/pariswells.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","name":"Research"}},{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","position":2,"name":"Research","item":"https:\/\/pariswells.com\/blog\/category\/research","nextItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#listItem","name":"Worksite\\iManage &#8211; SQL to change the owner of Workspace\/Folder"},"previousItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#listItem","position":3,"name":"Worksite\\iManage &#8211; SQL to change the owner of Workspace\/Folder","previousItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","name":"Research"}}]},{"@type":"Organization","@id":"https:\/\/pariswells.com\/blog\/#organization","name":"Welcome to Pariswells.com","url":"https:\/\/pariswells.com\/blog\/"},{"@type":"Person","@id":"https:\/\/pariswells.com\/blog\/author\/paris#author","url":"https:\/\/pariswells.com\/blog\/author\/paris","name":"paris","image":{"@type":"ImageObject","@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/93b8ee3f592ac401167f870452bd82d43de80152cd3524e2853403658ada9984?s=96&d=mm&r=g","width":96,"height":96,"caption":"paris"}},{"@type":"WebPage","@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#webpage","url":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder","name":"Worksite\\iManage \u2013 SQL to change the owner of Workspace\/Folder | Welcome to Pariswells.com","description":"Here are the steps to change the owner of Workspace\/Folder in Worksite 10--To change the owner of a Workspace\/Folder, first we need to find the prj_id of the Workspace\/Folder select * where prj_name LIKE '%FOLDER\\WORKSPACE_NAME%'--To change it to a different owner...update mhgroup.projects set prj_owner = 'NEW_USERID' where prj_id = 'WORKSPACE_ID'After changing the owner of the workspace,","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/pariswells.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder#breadcrumblist"},"author":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"creator":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"datePublished":"2019-07-10T11:18:37+00:00","dateModified":"2019-07-10T11:18:37+00:00"},{"@type":"WebSite","@id":"https:\/\/pariswells.com\/blog\/#website","url":"https:\/\/pariswells.com\/blog\/","name":"Welcome to Pariswells.com","inLanguage":"en-US","publisher":{"@id":"https:\/\/pariswells.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Welcome to Pariswells.com |","og:type":"article","og:title":"Worksite\\iManage \u2013 SQL to change the owner of Workspace\/Folder | Welcome to Pariswells.com","og:description":"Here are the steps to change the owner of Workspace\/Folder in Worksite 10--To change the owner of a Workspace\/Folder, first we need to find the prj_id of the Workspace\/Folder select * where prj_name LIKE '%FOLDER\\WORKSPACE_NAME%'--To change it to a different owner...update mhgroup.projects set prj_owner = 'NEW_USERID' where prj_id = 'WORKSPACE_ID'After changing the owner of the workspace,","og:url":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder","article:published_time":"2019-07-10T11:18:37+00:00","article:modified_time":"2019-07-10T11:18:37+00:00","twitter:card":"summary","twitter:title":"Worksite\\iManage \u2013 SQL to change the owner of Workspace\/Folder | Welcome to Pariswells.com","twitter:description":"Here are the steps to change the owner of Workspace\/Folder in Worksite 10--To change the owner of a Workspace\/Folder, first we need to find the prj_id of the Workspace\/Folder select * where prj_name LIKE '%FOLDER\\WORKSPACE_NAME%'--To change it to a different owner...update mhgroup.projects set prj_owner = 'NEW_USERID' where prj_id = 'WORKSPACE_ID'After changing the owner of the workspace,"},"aioseo_meta_data":{"post_id":"4254","title":null,"description":null,"keywords":null,"keyphrases":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":[]},"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,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 05:30:04","updated":"2022-09-14 15:33:37","primary_term":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/pariswells.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/pariswells.com\/blog\/category\/research\" title=\"Research\">Research<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tWorksite\\iManage \u2013 SQL to change the owner of Workspace\/Folder\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/pariswells.com\/blog"},{"label":"Research","link":"https:\/\/pariswells.com\/blog\/category\/research"},{"label":"Worksite\\iManage &#8211; SQL to change the owner of Workspace\/Folder","link":"https:\/\/pariswells.com\/blog\/research\/worksiteimanage-sql-to-change-the-owner-of-workspace-folder"}],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=4254"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4254\/revisions"}],"predecessor-version":[{"id":4255,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4254\/revisions\/4255"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=4254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=4254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=4254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}