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;

/



11 views0 comments

Recent Posts

See All

Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set serveroutput on format wrapped set def off set tab off exec dbms_metad

Cancelled scheduled concurrent requests

This SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for identifying scheduled requests that failed to be resubmitted. select

Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id numeric(10) not null, supplier_name varchar2(50) not null, contact_na