/* Formatted on 2018/3/15 13:05:39 (QP5 v5.256.13226.35538) */
--查询默认应用用户,比如是否需要锁定、修改这些用户
SELECT ROWID
, user_name
, description
, password_lifespan_days
, password_lifespan_accesses
, email_address
, fax
, start_date
, end_date
, user_id
, last_logon_date
, encrypted_foundation_password
, encrypted_user_password
, password_date
, password_accesses_left
, employee_id
, customer_id
, supplier_id
, person_party_id
, session_number
, last_update_date
, last_updated_by
, created_by
, creation_date
, last_update_login
FROM apps.fnd_user
WHERE user_name IN ('AME_INVALID_APPROVER'
, 'ANONYMOUS'
, 'APPSMGR'
, 'ASADMIN'
, 'ASGADM'
, 'ASGUEST'
, 'AUTOINSTALL'
, 'CONCURRENT MANAGER'
, 'FEEDER SYSTEM'
, 'GUEST'
, 'IBE_ADMIN'
, 'IBE_GUEST'
, 'IBEGUEST'
, 'IEXADMIN'
, 'INDUSTRY DATA'
, 'INITIAL SETUP'
, 'IRC_EMP_GUEST'
, 'IRC_EXT_GUEST'
, 'MOBILEADM'
, 'MOBILEDEV'
, 'OP_CUST_CARE_ADMIN'
, 'OP_SYSADMIN'
, 'ORACLE12.0.0'
, 'ORACLE12.1.0'
, 'ORACLE12.2.0'
, 'ORACLE12.3.0'
, 'ORACLE12.4.0'
, 'ORACLE12.5.0'
, 'ORACLE12.6.0'
, 'ORACLE12.7.0'
, 'ORACLE12.8.0'
, 'ORACLE12.9.0'
, 'PORTAL30'
, 'PORTAL30_SSO'
, 'STANDALONE BATCH PROCESS'
, 'SYSADMIN'
, 'WIZARD'
, 'XML_USER')
AND end_date IS NULL
ORDER BY 1
--WEB窗口查不到的用户是ANONYMOUS、AUTOINSTALL、INITIAL SETUP、FEEDER SYSTEM、CONCURRENT MANAGER、STANDALONE BATCH PROCESS,所以这些用户无法自己手工禁用即在web页面吧end_date设置为null,但是这几个用户的end_date系统已经默认为1951/1/1即已经自动禁用,只有AUTOINSTALL在上述语句中能查到,所以AUTOINSTALL不能禁用只能修改密码