Unlock and Change Oracle APEX Password

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Unlock and Change Oracle APEX Password

Post by admin »

Here are steps to change your Oracle APEX admin password, APEX_220200 schema is your current schema as per your version of APEX,

Code: Select all

SELECT * FROM APEX_220200.WWV_FLOW_FND_USER A 
WHERE ACCOUNT_LOCKED = 'Y';

BEGIN
   APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => 10);
   APEX_UTIL.UNLOCK_ACCOUNT(P_USER_NAME => 'ADMIN');

UPDATE APEX_220200.WWV_FLOW_FND_USER SET WEB_PASSWORD = 'XXXXXXXXX' 
WHERE  USER_NAME = 'ADMIN';

   COMMIT;
END;
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest