ITPub博客

首页 > 数据库 > Oracle > Oracle EBS默认的账户

Oracle EBS默认的账户

原创 Oracle 作者:pan_tian 时间:2014-07-02 12:14:12 0 删除 编辑

DB的默认账户及密码

system/manager

sys/manager(或者change_on_install)

apps/apps

inv/inv

wms/wms

wip/wip

po/po

......

Vision Demo库默认的用户名及密码

sysadmin/sysadmin
mfg/welcome
operations/welcome
services/welcome
mrc/welcome
hrms/welocme
projmfg/welcome (For Project)
process_ops/welcome(FOR OPM)
INVPLANNER/welcome

MRC/welcome



A Script: EBS Apps passwords - $FND_TOP/patch/115/sql/fnddefpw.sql – will list seeded accounts with default password 

select USER_NAME USER_WITH_DEFAULT_PASSWORD from (
          select fnd_web_sec.validate_login(\'AME_INVALID_APPROVER\',\'WELCOME\') R, \'AME_INVALID_APPROVER\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'ANONYMOUS\',\'welcome\') R, \'ANONYMOUS\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'APPSMGR\',\'C\') R, \'APPSMGR\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'ASGADM\',\'ASGADM\') R, \'ASGADM\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'ASGADM\',\'welcome\') R, \'ASGADM\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'ASGUEST\',\'welcome\') R, \'ASGUEST\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'AUTOINSTALL\',\'DATAMERGE\') R, \'AUTOINSTALL\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'GUEST\',\'ORACLE\') R, \'GUEST\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'IBEGUEST\',\'IBEGUEST2000\') R, \'IBEGUEST\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'IBE_ADMIN\',\'MANAGER\') R, \'IBE_ADMIN\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'IBE_GUEST\',\'WELCOME\') R, \'IBE_GUEST\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'IEXADMIN\',\'COLLECTIONS\') R, \'IEXADMIN\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'IRC_EMP_GUEST\',\'WELCOME\') R, \'IRC_EMP_GUEST\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'IRC_EXT_GUEST\',\'WELCOME\') R, \'IRC_EXT_GUEST\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'MOBADM\',\'C\') R, \'MOBADM\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'MOBDEV\',\'C\') R, \'MOBDEV\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'MOBILEADM\',\'MOBILEADM\') R, \'MOBILEADM\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'MOBILEADM\',\'welcome\') R, \'MOBILEADM\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'OP_CUST_CARE_ADMIN\',\'OP_CUST_CARE_ADMIN\') R, \'OP_CUST_CARE_ADMIN\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'OP_SYSADMIN\',\'OP_SYSADMIN\') R, \'OP_SYSADMIN\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'PORTAL30\',\'PORTAL30\') R, \'PORTAL30\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'PORTAL30\',\'portal30_new\') R, \'PORTAL30\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'PORTAL30_SSO\',\'portal30_sso_new\') R, \'PORTAL30_SSO\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'SYSADMIN\',\'SYSADMIN\') R, \'SYSADMIN\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'WIZARD\',\'????UE:?H0UA}?K\') R, \'WIZARD\' USER_NAME from dual
union ALL select fnd_web_sec.validate_login(\'XML_USER\',\'WELCOME\') R, \'XML_USER\' USER_NAME from dual
) where R=\'Y\';



<!-- Baidu Button BEGIN -->

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26687597/viewspace-1203624/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: [文档]Oracle EBS深入浅出系列
下一篇: Oracle Application Server上不同类型的文件所在的目录
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2012-02-18

最新文章