Set up default password for APEX ADMIN user

wnameless · wnameless · commit 32fd16aeb290 · 2018-05-30T01:36:38.000+08:00
diff --git a/README.md b/README.md
@@ -33,28 +33,20 @@ For performance concern, you may want to disable the disk asynch IO:
 docker run -d -p 49161:1521 -e ORACLE_DISABLE_ASYNCH_IO=true wnameless/oracle-xe-11g
 ```
 
-For XDB user, run this:
+Enable XDB user with default password: xdb, run this:
 ```
-docker run -d -p 49161:1521 -p 8080:8080 -e ORACLE_ENABLE_XDB=true wnameless/oracle-xe-11g
+docker run -d -p 49161:1521 -e ORACLE_ENABLE_XDB=true wnameless/oracle-xe-11g
 ```
 
-Check if localhost:8080 work
+For APEX user:
 ```
-curl -XGET "http://localhost:8080"
-```
-You will show
-```
-<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
-<HTML><HEAD>
-<TITLE>401 Unauthorized</TITLE>
-</HEAD><BODY><H1>Unauthorized</H1>
-</BODY></HTML>
+docker run -d -p 49161:1521 -p 8080:8080 wnameless/oracle-xe-11g
 ```
 
 ```
-# Login http://localhost:8080 with following credential:
-username: XDB
-password: xdb
+# Login http://localhost:8080/apex/apex_admin with following credential:
+username: ADMIN
+password: admin
 ```
 
 By default, the password verification is disable(password never expired)<br/>
diff --git a/assets/apex-default-pwd.sql b/assets/apex-default-pwd.sql
@@ -0,0 +1,25 @@
+alter session set current_schema = APEX_040000;
+
+begin
+
+    wwv_flow_security.g_security_group_id := 10;
+    wwv_flow_security.g_user := 'ADMIN';
+    wwv_flow_security.g_import_in_progress := true;
+
+    for c1 in (select user_id
+                 from wwv_flow_fnd_user
+                where security_group_id = wwv_flow_security.g_security_group_id
+                  and user_name = wwv_flow_security.g_user) loop
+
+        wwv_flow_fnd_user_api.edit_fnd_user(
+            p_user_id       => c1.user_id,
+            p_user_name     => wwv_flow_security.g_user,
+            p_web_password  => 'admin',
+            p_new_password  => 'admin');
+    end loop;
+
+    wwv_flow_security.g_import_in_progress := false;
+
+end;
+/
+commit;
diff --git a/assets/setup.sh b/assets/setup.sh
@@ -32,9 +32,6 @@ echo 'export ORACLE_SID=XE' >> /etc/bash.bashrc &&
 mv /assets/startup.sh /usr/sbin/startup.sh &&
 chmod +x /usr/sbin/startup.sh &&
 
-# Remove installation files
-rm -r /assets/ &&
-
 # Create initialization script folders
 mkdir /docker-entrypoint-initdb.d
 
@@ -46,5 +43,9 @@ export ORACLE_SID=XE
 echo "ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;" | sqlplus -s SYSTEM/oracle
 echo "alter profile DEFAULT limit password_life_time UNLIMITED;" | sqlplus -s SYSTEM/oracle
 echo "alter user SYSTEM identified by oracle account unlock;" | sqlplus -s SYSTEM/oracle
+cat /assets/apex-default-pwd.sql | sqlplus -s SYSTEM/oracle
+
+# Remove installation files
+rm -r /assets/
 
 exit $?
