DBA Hub

📋Steps in this guide1/2

Oracle Application Express (APEX) : Change the Admin Password

This article describes the two methods of changing the admin password for APEX.

oracle miscconfigurationintermediate
by OracleDba
15 views
1

Using apxchpwd.sql

If you have the APEX software available you can use the "apxchpwd.sql" script. Change to the directory with the APEX software, connect to SQL*Plus as the SYS user and run the "apxchpwd.sql" script, specifying the credentials when prompted.

Code/Command (click line numbers to comment):

1
2
SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apxchpwd.sql
2

Using SQL

Change the current schema to the one relevant for your APEX version and find the admin user in the table. Update the password in the user record you found previously. Unlock the user. For more information see: - APEX Articles Hope this helps. Regards Tim...

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
ALTER SESSION SET CURRENT_SCHEMA = APEX_190100;

COLUMN user_id Format 99999999999999999
COLUMN first_name FORMAT A20
COLUMN last_name FORMAT A20
COLUMN default_schema FORMAT A30

SELECT user_id,
       first_name,
       last_name,
       default_schema
FROM   wwv_flow_fnd_user
WHERE  user_name = 'ADMIN'
ORDER BY last_update_date DESC;

           USER_ID FIRST_NAME           LAST_NAME            DEFAULT_SCHEMA
------------------ -------------------- -------------------- ------------------------------
  1250128976437207                                           APEX_190100

SQL>

UPDATE wwv_flow_fnd_user
SET    web_password = 'ApexPassword1'
WHERE  user_name = 'ADMIN'
AND    user_id = 1250128976437207;

COMMIT;

BEGIN
  WWV_FLOW_SECURITY.g_security_group_id := 10;
  WWV_FLOW_FND_USER_API.unlock_account('ADMIN');
  COMMIT;
END;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!