Search

Decrypt user's password in EBS

-- Create java function for decrypting password

-- key - apps password (upper case)

-- value - encrypted user password


create or replace function xxx_decrypt (key in varchar2, value in varchar2) return varchar2

as language java name 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';

/


-- Decrypt user's password

-- Change SYSADMIN to whatever you need


select user_name, xxx_decrypt('APPS', encrypted_user_password) from fnd_user where user_name = 'SYSADMIN';



1 view0 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