Search

APEX - change user's password

sqlplus / as sysdba


select owner, table_name from dba_tables where table_name = upper('wwv_flow_fnd_user');


-- Change schema name to whatever you want

ALTER SESSION SET CURRENT_SCHEMA = APEX_050100;


set lines 100

COLUMN user_id Format 99999999999999999

COLUMN user_name FORMAT A20

COLUMN default_schema FORMAT A30


-- Change user name to whatever you want

SELECT user_id,

user_name,

default_schema

FROM wwv_flow_fnd_user

WHERE user_name = 'ADMIN'

ORDER BY last_update_date DESC;


-- Change user name and user Id and <password> to whatever you want

UPDATE wwv_flow_fnd_user

SET web_password = '<password>'

WHERE user_name = 'ADMIN'

AND user_id = 1814258022160324;


COMMIT;

exit;


BEGIN

WWV_FLOW_SECURITY.g_security_group_id := 10;

WWV_FLOW_FND_USER_API.unlock_account('ADMIN');

COMMIT;

END;

/



2 views0 comments

Recent Posts

See All

After logon trigger - trace user sessions

-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the conditions for activating trace -- SYS.XX_LOGIN_TRACED_SESSIONS - con

INCLUDE parameter of expdp

-- Export all public database links expdp user/password full=y \ include=db_link:"in (select db_link from dba_db_links where owner = 'PUBLIC')" -- Export one table expdp user/password include=table:"i

Multiplexing Redo Log and Control files

-- List redo log files select group#, member from v$logfile order by group#, member; -- Check redo log file status select group#, members, status from v$log; -- Adding redo log file to a group alter d