禁用oracle的默认账户,Oracle EBS默认的账户

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';