{"id":1642,"date":"2024-03-06T14:28:52","date_gmt":"2024-03-06T13:28:52","guid":{"rendered":"https:\/\/chaoyu.nl\/?p=1642"},"modified":"2024-03-06T15:36:52","modified_gmt":"2024-03-06T14:36:52","slug":"switch-between-apex-builder-authentication-schemes","status":"publish","type":"post","link":"https:\/\/chaoyu.nl\/?p=1642","title":{"rendered":"Switch Between APEX builder Authentication schemes"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">when on OCI internal workspace, first thing you should be doing after you switch authentication is create users that can access internal workspace other than the ADMIN account. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is possible that you are forever logged out and need to do a db rollback&#8230;. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">begin \n  apex_instance_admin.set_parameter('APEX_BUILDER_AUTHENTICATION','APEX'); -- to use apex users\n  apex_instance_admin.set_parameter('APEX_BUILDER_AUTHENTICATION','DB'); -- to use database users, this also means each time you create a new user, this user is also a db user\n  \nend;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>APEX<\/code>&nbsp;&#8211;&nbsp;Oracle APEX&nbsp;workspace accounts authentication<\/li>\n\n\n\n<li><code>DB<\/code>&nbsp;&#8211; Database accounts authentication  (default on OCI)<\/li>\n\n\n\n<li><code>HEADER<\/code>&nbsp;&#8211; HTTP header variable based authentication<\/li>\n\n\n\n<li><code>SSO<\/code>&nbsp;&#8211;&nbsp;Oracle&nbsp;Application Server Single Sign-On authentication (OracleAS PL\/SQL SSO SDK)<\/li>\n\n\n\n<li><code>LDAP<\/code>&nbsp;&#8211; LDAP authentication<\/li>\n\n\n\n<li><code>SAML<\/code>&nbsp;&#8211; SAML Sign-In authentication<\/li>\n\n\n\n<li><code>SOCIAL<\/code>&nbsp;&#8211; Social Sign-In authentication<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>when on OCI internal workspace, first thing you should be doing after you switch authentication is create users that can access internal workspace other than the ADMIN account. It is possible that you are forever logged out and need to do a db rollback&#8230;.<\/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":[],"class_list":["post-1642","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/1642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1642"}],"version-history":[{"count":6,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/1642\/revisions"}],"predecessor-version":[{"id":1648,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/1642\/revisions\/1648"}],"wp:attachment":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}