EBS查询默认应用用户，比如是否需要锁定、修改这些用户

/* 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不能禁用只能修改密码