Oracle Apex Şifre Sıfırlama

Oracle Dec 26, 2022 Özgür Fidan oracle apex apex

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;