How to change ADMIN password or Unlock Account?

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:

How to change ADMIN password or Unlock Account?

Post by admin »

If your ADMIN users password is missing then login to the database as sys users and execute following script from your APEX folder,

SQL> @apxchpwd.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN] << Here hit enter
User "ADMIN" exists.
Enter ADMIN's email [info@erpstuff.com] << Here hit enter
Enter ADMIN's password []
Changed password of instance administrator ADMIN. << Provide a new password

SQL> commit;

Now login as admin in INTERNAL workspace.

Another possibility is if your ADMIN account is locked then try the following,

BEGIN
apex_util.set_security_group_id(p_security_group_id => 10);
apex_util.unlock_account(p_user_name => 'ADMIN');
END;
/
COMMIT;
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests