{"id":9247,"date":"2019-09-24T14:01:47","date_gmt":"2019-09-24T20:01:47","guid":{"rendered":"https:\/\/traust.com\/?p=9247"},"modified":"2021-06-23T13:51:13","modified_gmt":"2021-06-23T18:51:13","slug":"user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme","status":"publish","type":"post","link":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/","title":{"rendered":"User Self-Registration in Oracle APEX: Using the Application Express Accounts Authentication Scheme"},"content":{"rendered":"<p>Self-Registration in <a href=\"https:\/\/traust.com\/enterprise-web-apps\/\">Oracle APEX<\/a> is not terribly common because most use cases involve users being managed by LDAP, database accounts, or single sign-on. When the above are not the case, usually something like a social sign-in, custom authentication, or no authentication will suffice. There are exceptions however, and every so often it makes sense to want to use APEX accounts for authentication.<\/p>\n<p>The typical situation for this use case involves one or more of the following:<\/p>\n<ul>\n<li>A smaller organization or limited number of users<\/li>\n<li>Need for a more robust security than social sign-in<\/li>\n<li>Not having the expertise or faith in setting up\/managing custom authentication<\/li>\n<\/ul>\n<h2>Pros of APEX Self-Registration \u2014 APEX Authentication<\/h2>\n<ul>\n<li>Very secure if done correctly<\/li>\n<li>Easy to manage<\/li>\n<li>Intuitive<\/li>\n<\/ul>\n<h2>Cons of APEX Self-Registration \u2014 APEX Authentication<\/h2>\n<ul>\n<li>Potential security risk if users are not properly assigned as an end-user<\/li>\n<li>Questions of scalability if the system needs to support many users<\/li>\n<\/ul>\n<p>For this blog post, I will walk you through the steps of creating your own self-registration process in APEX. The purpose of this post is to get you to understand what API calls are needed, how things work, and why they work that way. Please do not follow the steps in the example and put that into production as-is. The instruction guide does not take you through the extra steps of setting up validation, session state protection, and adding extra layers of security with authentication\/authorization.<\/p>\n<p>Requirements<\/p>\n<ul>\n<li>APEX 18.1 or higher<\/li>\n<li>Oracle DB 12.2.0.1 or higher<\/li>\n<li>Oracle DB access with sys or sysdba<\/li>\n<\/ul>\n<p>Files Included<\/p>\n<ul>\n<li><em><a href=\"https:\/\/traust.com\/wp-content\/uploads\/2019\/09\/Traust-APEX-Blog-Self-Registration-Instruction-Guide.pdf\">Traust APEX Blog &#8211; Self-Registration Instruction Guide.pdf<\/a><\/em><\/li>\n<li><a href=\"https:\/\/traust.com\/wp-content\/uploads\/2019\/09\/Traust-APEX-Blog-Self-Registration-Example.txt\">Traust APEX Blog &#8211; Self-Registration Example.txt<\/a><\/li>\n<\/ul>\n<hr \/>\n<p><em>Disclaimer:\u00a0<\/em><em>We do not take responsibility for any unintended or unwanted consequences in your instance of Oracle, Oracle APEX, or related products as a result of reading our blogs or following our guides.\u00a0 Though the information is fully tested and generally safe to use, our lawyers really have a thing against admitting potential wrongdoing.\u00a0 If it makes you feel any better, I occasionally turn the brightness down on their monitors to make them think it is broken.\u00a0 When they order a new one, I take the old one, restore the brightness settings, and donate it to a school.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Self-Registration in Oracle APEX is not terribly common because most use cases involve users being managed by LDAP, database accounts, or single sign-on. When the above are not the case,&#8230;<\/p>\n","protected":false},"author":17,"featured_media":7699,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[50,35,52],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using the Oracle APEX Accounts Authentication Scheme - Traust<\/title>\n<meta name=\"description\" content=\"Oracle Developer &amp; APEX Specialist, Andrew Schultz, walks you through the steps of creating your own self-registration process in APEX.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using the Oracle APEX Accounts Authentication Scheme - Traust\" \/>\n<meta property=\"og:description\" content=\"Oracle Developer &amp; APEX Specialist, Andrew Schultz, walks you through the steps of creating your own self-registration process in APEX.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/\" \/>\n<meta property=\"og:site_name\" content=\"Traust\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-24T20:01:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-23T18:51:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1404\" \/>\n\t<meta property=\"og:image:height\" content=\"936\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Andrew Schultz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@TraustConsult\" \/>\n<meta name=\"twitter:site\" content=\"@TraustConsult\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andrew Schultz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/\"},\"author\":{\"name\":\"Andrew Schultz\",\"@id\":\"https:\/\/traust.com\/#\/schema\/person\/e433f83ed21d5947cde6cc0067f9c628\"},\"headline\":\"User Self-Registration in Oracle APEX: Using the Application Express Accounts Authentication Scheme\",\"datePublished\":\"2019-09-24T20:01:47+00:00\",\"dateModified\":\"2021-06-23T18:51:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/\"},\"wordCount\":377,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/traust.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg\",\"articleSection\":[\"APEX\",\"IT\",\"Technical\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/\",\"url\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/\",\"name\":\"Using the Oracle APEX Accounts Authentication Scheme - Traust\",\"isPartOf\":{\"@id\":\"https:\/\/traust.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg\",\"datePublished\":\"2019-09-24T20:01:47+00:00\",\"dateModified\":\"2021-06-23T18:51:13+00:00\",\"description\":\"Oracle Developer & APEX Specialist, Andrew Schultz, walks you through the steps of creating your own self-registration process in APEX.\",\"breadcrumb\":{\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#primaryimage\",\"url\":\"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg\",\"contentUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg\",\"width\":1404,\"height\":936,\"caption\":\"male caucasian electrician checking industrial machine control box temperature\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/traust.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"User Self-Registration in Oracle APEX: Using the Application Express Accounts Authentication Scheme\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/traust.com\/#website\",\"url\":\"https:\/\/traust.com\/\",\"name\":\"Traust Consulting\",\"description\":\"Enterprise Solutions. Tailored to Work.\",\"publisher\":{\"@id\":\"https:\/\/traust.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/traust.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/traust.com\/#organization\",\"name\":\"Traust\",\"url\":\"https:\/\/traust.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/traust.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/traust.com\/wp-content\/uploads\/2020\/05\/Traust-Logo-2.png\",\"contentUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2020\/05\/Traust-Logo-2.png\",\"width\":200,\"height\":200,\"caption\":\"Traust\"},\"image\":{\"@id\":\"https:\/\/traust.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/TraustConsult\",\"https:\/\/www.linkedin.com\/company\/traust-consulting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/traust.com\/#\/schema\/person\/e433f83ed21d5947cde6cc0067f9c628\",\"name\":\"Andrew Schultz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/traust.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3dc445221a43d9535221babd6bb2a1e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3dc445221a43d9535221babd6bb2a1e?s=96&d=mm&r=g\",\"caption\":\"Andrew Schultz\"},\"description\":\"Andrew is a Senior Oracle Application Express (APEX) developer with more than 10 years of experience leading projects from inception to completion. He has built and maintained more than 750 Oracle APEX forms and reports. His prior work as a technical writer and client educator has uniquely prepared Andrew to identify the needs of a task from the perspectives of the organization, programmer, client, and end-user.\",\"url\":\"https:\/\/traust.com\/blog\/author\/aschultz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using the Oracle APEX Accounts Authentication Scheme - Traust","description":"Oracle Developer & APEX Specialist, Andrew Schultz, walks you through the steps of creating your own self-registration process in APEX.","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:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/","og_locale":"en_US","og_type":"article","og_title":"Using the Oracle APEX Accounts Authentication Scheme - Traust","og_description":"Oracle Developer & APEX Specialist, Andrew Schultz, walks you through the steps of creating your own self-registration process in APEX.","og_url":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/","og_site_name":"Traust","article_published_time":"2019-09-24T20:01:47+00:00","article_modified_time":"2021-06-23T18:51:13+00:00","og_image":[{"width":1404,"height":936,"url":"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg","type":"image\/jpeg"}],"author":"Andrew Schultz","twitter_card":"summary_large_image","twitter_creator":"@TraustConsult","twitter_site":"@TraustConsult","twitter_misc":{"Written by":"Andrew Schultz","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#article","isPartOf":{"@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/"},"author":{"name":"Andrew Schultz","@id":"https:\/\/traust.com\/#\/schema\/person\/e433f83ed21d5947cde6cc0067f9c628"},"headline":"User Self-Registration in Oracle APEX: Using the Application Express Accounts Authentication Scheme","datePublished":"2019-09-24T20:01:47+00:00","dateModified":"2021-06-23T18:51:13+00:00","mainEntityOfPage":{"@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/"},"wordCount":377,"commentCount":0,"publisher":{"@id":"https:\/\/traust.com\/#organization"},"image":{"@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#primaryimage"},"thumbnailUrl":"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg","articleSection":["APEX","IT","Technical"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/","url":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/","name":"Using the Oracle APEX Accounts Authentication Scheme - Traust","isPartOf":{"@id":"https:\/\/traust.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#primaryimage"},"image":{"@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#primaryimage"},"thumbnailUrl":"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg","datePublished":"2019-09-24T20:01:47+00:00","dateModified":"2021-06-23T18:51:13+00:00","description":"Oracle Developer & APEX Specialist, Andrew Schultz, walks you through the steps of creating your own self-registration process in APEX.","breadcrumb":{"@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#primaryimage","url":"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg","contentUrl":"https:\/\/traust.com\/wp-content\/uploads\/2016\/07\/Tech-Heat-Testing-Panel-Web-Optomized.jpg","width":1404,"height":936,"caption":"male caucasian electrician checking industrial machine control box temperature"},{"@type":"BreadcrumbList","@id":"https:\/\/traust.com\/blog\/user-self-registration-in-oracle-apex-using-the-application-express-accounts-authentication-scheme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/traust.com\/"},{"@type":"ListItem","position":2,"name":"User Self-Registration in Oracle APEX: Using the Application Express Accounts Authentication Scheme"}]},{"@type":"WebSite","@id":"https:\/\/traust.com\/#website","url":"https:\/\/traust.com\/","name":"Traust Consulting","description":"Enterprise Solutions. Tailored to Work.","publisher":{"@id":"https:\/\/traust.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/traust.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/traust.com\/#organization","name":"Traust","url":"https:\/\/traust.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/traust.com\/#\/schema\/logo\/image\/","url":"https:\/\/traust.com\/wp-content\/uploads\/2020\/05\/Traust-Logo-2.png","contentUrl":"https:\/\/traust.com\/wp-content\/uploads\/2020\/05\/Traust-Logo-2.png","width":200,"height":200,"caption":"Traust"},"image":{"@id":"https:\/\/traust.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/TraustConsult","https:\/\/www.linkedin.com\/company\/traust-consulting\/"]},{"@type":"Person","@id":"https:\/\/traust.com\/#\/schema\/person\/e433f83ed21d5947cde6cc0067f9c628","name":"Andrew Schultz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/traust.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3dc445221a43d9535221babd6bb2a1e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3dc445221a43d9535221babd6bb2a1e?s=96&d=mm&r=g","caption":"Andrew Schultz"},"description":"Andrew is a Senior Oracle Application Express (APEX) developer with more than 10 years of experience leading projects from inception to completion. He has built and maintained more than 750 Oracle APEX forms and reports. His prior work as a technical writer and client educator has uniquely prepared Andrew to identify the needs of a task from the perspectives of the organization, programmer, client, and end-user.","url":"https:\/\/traust.com\/blog\/author\/aschultz\/"}]}},"_links":{"self":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/posts\/9247"}],"collection":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/comments?post=9247"}],"version-history":[{"count":0,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/posts\/9247\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/media\/7699"}],"wp:attachment":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/media?parent=9247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/categories?post=9247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/tags?post=9247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}