{"id":43582,"date":"2026-03-31T07:27:00","date_gmt":"2026-03-31T05:27:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=43582"},"modified":"2026-03-31T12:50:22","modified_gmt":"2026-03-31T10:50:22","slug":"the-undocumented-goldengate-all-role-you-should-know-about","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/","title":{"rendered":"The Undocumented GoldenGate &#8216;all&#8217; Role You Should Know About"},"content":{"rendered":"\n<p>Let me tell you a story about how <strong>I discovered an undocumented role in GoldenGate<\/strong> that could break your automation. Recently, I wanted to do a massive update of the role of a GoldenGate user on multiple deployments. First of all, you should know that <strong>GoldenGate users are assigned to a role<\/strong> within the following list: <code>User<\/code>, <code>Operator<\/code>, <code>Administrator<\/code> and <code>Security<\/code>.<\/p>\n\n\n\n<p>I will not dwell on the differences between them, but you just have to know something important here: <strong>you cannot change the role assigned to a GoldenGate user<\/strong>. If you try to edit a user, the only thing that you can change is the password.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"390\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4-1024x390.png\" alt=\"\" class=\"wp-image-43605\" style=\"width:800px\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4-1024x390.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4-300x114.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4-768x293.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4.png 1281w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>That being said, the <strong>only possible option to change the role of a user<\/strong> in GoldenGate is to <strong>recreate it<\/strong>. In the web UI, it is rather simple. You just delete it, and recreate it with the same credentials, but a different role.<\/p>\n\n\n\n<p>But as mentioned, I wanted to do it for multiple deployments and users, without having to do the operation manually.every time. That is why I decided to use the GoldenGate REST API to quickly iterate over users and deployments. And this is where the trouble began.<\/p>\n\n\n\n<p>According to the GoldenGate documentation on the REST API, there are two endpoints that appear to replicate the web UI behavior :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/goldengate\/core\/26\/oggra\/op-services-version-authorizations-role-user-delete.html\" target=\"_blank\" rel=\"noreferrer noopener\">Delete User<\/a> : <code>DELETE \/services\/{version}\/authorizations\/{role}\/{user}<\/code><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"118\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_delete_user.png\" alt=\"\" class=\"wp-image-43607\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_delete_user.png 555w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_delete_user-300x64.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/goldengate\/core\/26\/oggra\/op-services-version-authorizations-role-user-post.html\" target=\"_blank\" rel=\"noreferrer noopener\">Create User<\/a> : <code>POST \/services\/{version}\/authorizations\/{role}\/{user}<\/code><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"120\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_create_user-2.png\" alt=\"\" class=\"wp-image-43606\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_create_user-2.png 555w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_create_user-2-300x65.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure>\n<\/div>\n\n\n<p>However, <strong>when calling the API<\/strong> with these endpoints and the Python client I presented in <a href=\"https:\/\/www.dbi-services.com\/blog\/production-ready-goldengate-rest-client-in-python\/\" target=\"_blank\" rel=\"noreferrer noopener\">another blog<\/a>, I <strong>had the following error<\/strong> after trying to recreate the user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Deletion works as intended\n&gt;&gt;&gt; ogg_client.delete_user('dbiblog','Operator')\n{'$schema': 'api:standardResponse', 'links': &#091;{'rel': 'canonical', 'href': 'https:\/\/vmogg\/se\/Operator', 'mediaType': 'application\/json'}, {'rel': 'self', 'href': 'https:\/\/vmogg\/se\/Operator', 'mediaType': 'application\/json'}], 'messages': &#091;]}\n\n# Creation doesn't work\n&gt;&gt;&gt; ogg_client.create_user('dbiblog', 'User', data={'credential':'**'})\nException: ERROR - https:\/\/vmogg\/services\/ogg_test_01\/adminsrvr\/v2\/authorizations\/Operator\/dbiblog: The specified user already exists.<\/code><\/pre>\n\n\n\n<p>In the UI, <strong>the user was gone, but I couldn&#8217;t recreate it<\/strong> with the REST API. And even from the UI, the user couldn&#8217;t be recreated. Instead, I had the following error: <code>OGG-12430 : The specified user already exists.<\/code><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"221\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_err_webui-1024x221.png\" alt=\"\" class=\"wp-image-43608\" style=\"width:800px\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_err_webui-1024x221.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_err_webui-300x65.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_err_webui-768x166.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_err_webui.png 1304w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>At first, I thought something was wrong with either my deployment or my client, but I found nothing wrong. So I checked the <code>restapi.log<\/code> files of my deployment to understand:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>What the REST API calls were doing<\/li>\n\n\n\n<li>What the web UI was doing.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-restapi-log-analysis\"><code>restapi.log<\/code> analysis<\/h2>\n\n\n\n<p>Let&#8217;s try to create the exact same user (<code>dbiblog<\/code> \/ <code>Operator<\/code>) from the UI, and see <strong>what passes through the API<\/strong>. For more insight about how to query the <code>restapi.log<\/code> file efficiently, you can read a <a href=\"https:\/\/www.dbi-services.com\/blog\/querying-goldengate-rest-api-log-efficiently\/\" target=\"_blank\" rel=\"noreferrer noopener\">blog<\/a> I wrote on the topic. Otherwise, you can just search through the logs.<\/p>\n\n\n\n<p>As shown below, the <strong>creation of a user from the UI<\/strong> only generated one call to the API (excluding <code>GET<\/code> calls) to the same endpoint used by my method.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n&nbsp; \"content\": {\n&nbsp;&nbsp;&nbsp; \"credential\": \"** Masked **\",\n&nbsp;&nbsp;&nbsp; \"type\": \"Basic\"\n&nbsp; },\n&nbsp; \"uri\": \"\/services\/v2\/authorizations\/Operator\/dbiblog\",\n&nbsp; \"uriTemplate\": \"\/services\/{version}\/authorizations\/{role}\/{user}\",\n&nbsp; \"verb\": \"POST\",\n&nbsp; \"restapi_datetime\": \"2026-03-27 05:40:58.776+0000\",\n&nbsp; \"restapi_reqno\": 1840,\n&nbsp; \"restapi_service\": \"adminsrvr\",\n&nbsp; \"restapi_status\": \"INFO\"\n}<\/code><\/pre>\n\n\n\n<p>Now, when <strong>deleting the user from the UI<\/strong>, <strong>two <code>DELETE<\/code> operations<\/strong> go through the API.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n&nbsp; \"content\": null,\n&nbsp; \"uri\": \"\/services\/v2\/authorizations\/Operator\/dbiblog\",\n&nbsp; \"uriTemplate\": \"\/services\/{version}\/authorizations\/{role}\/{user}\",\n&nbsp; \"verb\": \"DELETE\",\n&nbsp; \"restapi_datetime\": \"2026-03-27 05:42:20.994+0000\",\n&nbsp; \"restapi_reqno\": 1926,\n&nbsp; \"restapi_service\": \"adminsrvr\",\n&nbsp; \"restapi_status\": \"INFO\"\n}\n{\n&nbsp; \"content\": null,\n&nbsp; \"uri\": \"\/services\/v2\/authorizations\/all\/dbiblog\",\n&nbsp; \"uriTemplate\": \"\/services\/{version}\/authorizations\/{role}\/{user}\",\n&nbsp; \"verb\": \"DELETE\",\n&nbsp; \"restapi_datetime\": \"2026-03-27 05:42:21.012+0000\",\n&nbsp; \"restapi_reqno\": 1927,\n&nbsp; \"restapi_service\": \"adminsrvr\",\n&nbsp; \"restapi_status\": \"INFO\"\n}<\/code><\/pre>\n\n\n\n<p>On top of making a <code>DELETE<\/code> call to the <code>dbiblog<\/code> \/ <code>Operator<\/code> pair, the UI generates another <code>DELETE<\/code> call on the <code>dbiblog<\/code> user with an undocumented <code>all<\/code> role !<\/p>\n\n\n\n<p>This <strong>explains why you get an error<\/strong> when recreating a user with the REST API. If the user was deleted by a single REST API call, <strong>it still exists with the hidden <code>all<\/code> role<\/strong>.<\/p>\n\n\n\n<p>To verify this hypothesis, let&#8217;s look at the <strong>list of users<\/strong> with the <code>Operator<\/code> and <code>all<\/code> roles <strong>before and after the user creation<\/strong>. <strong>Before<\/strong>, we only have the default <code>ogg<\/code> user (with the <code>Security<\/code> role, not shown here).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt;&gt;&gt; ogg_client.list_users('Operator')\n&#091;]\n\n&gt;&gt;&gt; ogg_client.list_users('all')\n&#091;{'username': 'ogg'}]<\/code><\/pre>\n\n\n\n<p>But <strong>after, the newly created user<\/strong> also gets the <code>all<\/code> role.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt;&gt;&gt; ogg_client.create_user(user='dbiblog', role='Operator', data={'credential':'**'})\n{'$schema': 'api:standardResponse', 'links': &#091;{'rel': 'canonical', 'href': 'https:\/\/vmogg\/ser\/Operator\/dbiblog', 'mediaType': 'application\/json'}, {'rel': 'self', 'href': 'https:\/\/vmogg\/ser\/Operator\/dbiblog', 'mediaType': 'application\/json'}], 'messages': &#091;]}\n\n&gt;&gt;&gt; ogg_client.list_users('Operator')\n&#091;{'username': 'dbiblog'}]\n\n&gt;&gt;&gt; ogg_client.list_users('all')\n&#091;{'username': 'ogg'}, {'username': 'dbiblog'}]<\/code><\/pre>\n\n\n\n<p>And of course, when deleting the user, <strong>I was only deleting it with the role I knew about<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-recreate-a-goldengate-user-with-the-rest-api\">How to recreate a GoldenGate user with the REST API ?<\/h2>\n\n\n\n<p>The conclusion is simple: to<strong> recreate a GoldenGate user with the REST API<\/strong>, you need to <strong>delete the user on its current role, but also on the <code>all<\/code> role<\/strong>. After doing this, you can recreate the user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># User deletion on the 'Operator' role\n&gt;&gt;&gt; ogg_client.delete_user(user='dbiblog', role='Operator')\n{'$schema': 'api:standardResponse', 'links': &#091;{'rel': 'canonical', 'href': 'https:\/\/vmogg\/Operator', 'mediaType': 'application\/json'}, {'rel': 'self', 'href': 'https:\/\/vmogg\/ser\/Operator', 'mediaType': 'application\/json'}], 'messages': &#091;]}\n\n# User deletion on the 'all' role\n&gt;&gt;&gt; ogg_client.delete_user(user='dbiblog', role='all')\n{'$schema': 'api:standardResponse', 'links': &#091;{'rel': 'canonical', 'href': 'https:\/\/vmogg\/ser\/All', 'mediaType': 'application\/json'}, {'rel': 'self', 'href': 'https:\/\/vmogg\/ser\/All', 'mediaType': 'application\/json'}], 'messages': &#091;]}\n\n# User creation on the 'Operator' role\n&gt;&gt;&gt; ogg_client.create_user(user='dbiblog', role='Operator', data={'credential':'**'})\n{'$schema': 'api:standardResponse', 'links': &#091;{'rel': 'canonical', 'href': 'https:\/\/vmogg\/ser\/Operator\/dbiblog', 'mediaType': 'application\/json'}, {'rel': 'self', 'href': 'https:\/\/vmogg\/ser\/Operator\/dbiblog', 'mediaType': 'application\/json'}], 'messages': &#091;]}<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Let me tell you a story about how I discovered an undocumented role in GoldenGate that could break your automation. Recently, I wanted to do a massive update of the role of a GoldenGate user on multiple deployments. First of all, you should know that GoldenGate users are assigned to a role within the following [&hellip;]<\/p>\n","protected":false},"author":152,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3787,59],"tags":[979,808,45,328,3730,3945,3853,3767,927,3942],"type_dbi":[3801,3941,3940,3740,3881,3946,3852,3769,3944,3943],"class_list":["post-43582","post","type-post","status-publish","format-standard","hentry","category-goldengate","category-oracle","tag-api","tag-delete","tag-documentation","tag-goldengate","tag-ogg","tag-ogg-12430","tag-recreate","tag-restapi","tag-role","tag-user","type-api","type-delete","type-documentation","type-goldengate","type-ogg","type-ogg-12430","type-recreate","type-restapi","type-role","type-user"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>The Undocumented GoldenGate &#039;all&#039; Role You Should Know About - dbi Blog<\/title>\n<meta name=\"description\" content=\"Here is how I discovered an undocumented role in GoldenGate, and why you should know about it when recreating users.\" \/>\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.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Undocumented GoldenGate &#039;all&#039; Role You Should Know About\" \/>\n<meta property=\"og:description\" content=\"Here is how I discovered an undocumented role in GoldenGate, and why you should know about it when recreating users.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-31T05:27:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-31T10:50:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1281\" \/>\n\t<meta property=\"og:image:height\" content=\"488\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Julien Delattre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julien Delattre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"headline\":\"The Undocumented GoldenGate &#8216;all&#8217; Role You Should Know About\",\"datePublished\":\"2026-03-31T05:27:00+00:00\",\"dateModified\":\"2026-03-31T10:50:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/\"},\"wordCount\":583,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/03\\\/ogg_blog_undocumented_role_1-4-1024x390.png\",\"keywords\":[\"api\",\"delete\",\"Documentation\",\"GoldenGate\",\"ogg\",\"ogg-12430\",\"recreate\",\"restapi\",\"role\",\"user\"],\"articleSection\":[\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/\",\"name\":\"The Undocumented GoldenGate 'all' Role You Should Know About - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/03\\\/ogg_blog_undocumented_role_1-4-1024x390.png\",\"datePublished\":\"2026-03-31T05:27:00+00:00\",\"dateModified\":\"2026-03-31T10:50:22+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"description\":\"Here is how I discovered an undocumented role in GoldenGate, and why you should know about it when recreating users.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/03\\\/ogg_blog_undocumented_role_1-4.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/03\\\/ogg_blog_undocumented_role_1-4.png\",\"width\":1281,\"height\":488},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-undocumented-goldengate-all-role-you-should-know-about\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Undocumented GoldenGate &#8216;all&#8217; Role You Should Know About\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\",\"name\":\"Julien Delattre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"caption\":\"Julien Delattre\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/juliendelattre\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Undocumented GoldenGate 'all' Role You Should Know About - dbi Blog","description":"Here is how I discovered an undocumented role in GoldenGate, and why you should know about it when recreating users.","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.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/","og_locale":"en_US","og_type":"article","og_title":"The Undocumented GoldenGate 'all' Role You Should Know About","og_description":"Here is how I discovered an undocumented role in GoldenGate, and why you should know about it when recreating users.","og_url":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/","og_site_name":"dbi Blog","article_published_time":"2026-03-31T05:27:00+00:00","article_modified_time":"2026-03-31T10:50:22+00:00","og_image":[{"width":1281,"height":488,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4.png","type":"image\/png"}],"author":"Julien Delattre","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julien Delattre","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"headline":"The Undocumented GoldenGate &#8216;all&#8217; Role You Should Know About","datePublished":"2026-03-31T05:27:00+00:00","dateModified":"2026-03-31T10:50:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/"},"wordCount":583,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4-1024x390.png","keywords":["api","delete","Documentation","GoldenGate","ogg","ogg-12430","recreate","restapi","role","user"],"articleSection":["GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/","url":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/","name":"The Undocumented GoldenGate 'all' Role You Should Know About - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4-1024x390.png","datePublished":"2026-03-31T05:27:00+00:00","dateModified":"2026-03-31T10:50:22+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"description":"Here is how I discovered an undocumented role in GoldenGate, and why you should know about it when recreating users.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/03\/ogg_blog_undocumented_role_1-4.png","width":1281,"height":488},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/the-undocumented-goldengate-all-role-you-should-know-about\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Undocumented GoldenGate &#8216;all&#8217; Role You Should Know About"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e","name":"Julien Delattre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","caption":"Julien Delattre"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/juliendelattre\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=43582"}],"version-history":[{"count":23,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43582\/revisions"}],"predecessor-version":[{"id":43696,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43582\/revisions\/43696"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=43582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=43582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=43582"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=43582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}