SQL> create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2
AS
LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
Function created.
SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';
ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZG4E96AA5DB997605414A6ABB412DEEBDF57BC6378816D2DABF4D1940952E17A1A31BA69B4193AAA
575A5C852D03AABA7845
SQL>
SQL>
SQL> SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZG4E96AA5DB997605414A6ABB412DEEBDF57BC6378816D2DABF4D1940952E17A1A31BA69B4193AAA575A5C852D03AABA7845') from dual;
APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZG4E96AA5DB997605414A6ABB412DEEBDF57BC6378
--------------------------------------------------------------------------------
apps
SQL>
SQL>
SQL> conn apps/apps
Connected.
SQL> show user
USER is "APPS"
SQL>
Comments
Post a Comment