Oracle Apex Şifre Sıfırlama

Oracle

Oracle Apex Password Reset

select username as schema_name
from sys.all_users where username like 'APEX%'
order by username;

APEX_220100

SCHEMA_NAME

APEX_220100

ALTER SESSION SET CURRENT_SCHEMA = APEX_220100;

SELECT USER_ID,USER_NAME FROM APEX_220100.WWV_FLOW_FND_USER;

USER_ID USER_NAME

58629402713811 ADMIN

şifre sıfırlama

UPDATE APEX_220100.WWV_FLOW_FND_USER

SET web_password = 'Apex_123'

WHERE user_name = 'ADMIN'

AND user_id =58629402713811;

Lock Kullanıcı Açma:

BEGIN

APEX_22010.WWV_FLOW_SECURITY.g_security_group_id := 10;

APEX_22010.WWV_FLOW_FND_USER_API.unlock_account('ADMIN');

COMMIT;

END;

1 min read

Feb 09, 2025

By Ozgur Fidan

Your email address will not be published. Required fields are marked *

Comment

Name

Website

Save my name, email, and website in this browser for the next time I comment.

Feb 09, 2025 • 1 min read

centos Error: Failed to download metadata for repo 'appstream': Cannot prepare internal mirrorlist:...

Feb 09, 2025 • 1 min read

Feb 09, 2025 • 2 min read

Related posts