CODEWITHSUNDEEP
oracle-databaseoracle-apex
Zesty
Zesty

Reputation: 2991

How can I reset the password of my workspace account in Oracle APEX?

I've gotten locked out of my Oracle APEX workspace. It is hosted locally, not in the Cloud.

The reset password won't help, as the account is tied to an email address of an employee who left.

The DBA has the credentials of an account of a different workspace.

Is there any procedure to reset this account's password?

Upvotes: 1

Views: 5280

Answers (2)

Koen Lostrie
Koen Lostrie

Reputation: 18665

There shouldn't be a need to update an internal apex table via sql. You can edit the users for any workspace from the INTERNAL workspace - that workspace is only used for instance administration. The default account for that workspace is ADMIN but you can created other users in that workspace as well. If the password for the admin account is lost it can be reset using the apxchpwd.sql script.

Upvotes: 3

cengiz sevimli
cengiz sevimli

Reputation: 2105

Do you have Database access? If yes, you can see the Apex table (it's schema named with the version like apex_210100) and under that, you will find WWV_FLOW_FND_USER table. Update that table's row with user_name = 'youruser' filtering.

i.e:

set ACCOUNT_LOCKED = 'N',FAILED_ACCESS_ATTEMPTS = 0, web_password = '12345',LAST_FAILED_LOGIN = NULL
where user_name = '[email protected]';
commit;

Upvotes: 6

Related Questions