mysql 密码反编译_忘记APPS密码 - EBS从数据库中反编译获取APPS密码

1.   获取GUEST用户密码(前台用户)

ERP中GUEST默认密码一般都是ORACLE

该密码可以从v$CONTEXT_FILE中得到

2.创建解密PACKAGE

CREATE OR REPLACE PACKAGE APPS.cux_fnd_web_sec AUTHID CURRENT_USER

AS

FUNCTION encrypt (

KEY   IN VARCHAR2,

VALUE IN VARCHAR2

)

RETURN VARCHAR2;

FUNCTION decrypt (

KEY IN VARCHAR2,

VALUE IN VARCHAR2

)

RETURN VARCHAR2;

END;

CREATE OR REPLACE PACKAGE BODY APPS.cux_fnd_web_sec

AS

FUNCTION encrypt (

KEY   IN VARCHAR2,

VALUE IN VARCHAR2

)

RETURN VARCHAR2

AS

LANGUAGE JAVA

NAME 'oracle.apps.fnd.security.WebSessionManagerProc.encrypt(java.lang.String,java.lang.String) return java.lang.String';

FUNCTION decrypt (

KEY IN VARCHAR2,

VALUE IN VARCHAR2

)

RETURN VARCHAR2

AS

LANGUAGE