Switch Between APEX builder Authentication schemes

Posted on

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…. 

begin 
  apex_instance_admin.set_parameter('APEX_BUILDER_AUTHENTICATION','APEX'); -- to use apex users
  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
  
end;
  • APEX – Oracle APEX workspace accounts authentication
  • DB – Database accounts authentication (default on OCI)
  • HEADER – HTTP header variable based authentication
  • SSO – Oracle Application Server Single Sign-On authentication (OracleAS PL/SQL SSO SDK)
  • LDAP – LDAP authentication
  • SAML – SAML Sign-In authentication
  • SOCIAL – Social Sign-In authentication

Leave a Reply