[oratest@ctssd ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 10:35:09 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show user
USER is "SYS"
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'; 2 3 4
5 /
Function created.
SQL> SELECT ENCRYPTED_FOUNDATION_PASSWORD from APPS.fnd_user where USER_NAME='GUEST';
ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZG2555C11618FBE5085594E7F69F0901785384BA78D95F98F252E44B9D043D0CD95DB2285AAA9B6A5A9F973D0B23859E0442
SQL> select apps.decrypt_pin_func('GUEST/ORACLE','ZG2555C11618FBE5085594E7F69F0901785384BA78D95F98F252E44B9D043D0CD95DB2285AAA9B6A5A9F973D0B23859E0442') from dual;
APPS.DECRYPT_PIN_FUNC2('GUEST/ORACLE','ZG2555C11618FBE5085594E7F69F0901785384BA7
--------------------------------------------------------------------------------
bo11yw00d
SQL> show user
USER is "SYS"
SQL> conn apps/bo11yw00d
Connected.
SQL> select name from v$database;
NAME
---------
ebstest
SQL>
Happy learning!!!!!!!
No comments:
Post a Comment