top of page
Search

Decrypt user's password in EBS

Writer's picture: mdvorkinmdvorkin

-- 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';



7 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...

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...

Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...

Comments


bottom of page