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

  • 相关阅读:
    转的。一个C#的问卷!private、 protected、 public、 internal 修饰符的访问权限
    Windows Phone Mango编程实践——第三方MVVM框架
    Windows Phone Mango编程实践——本地数据库
    Windows Phone Mango开发实践——Shake Library应用实例
    Windows Phone Mango开发实践——示例代码更新和提交(2013.09.12)
    《Windows Phone Mango开发实践》终于出版
    《Windows Phone Mango开发实践》即将问世
    Windows Phone Mango开发实践——应用程序生命周期
    Windows Phone Mango开发实践——性能分析工具
    XNA二维游戏的视差背景实现方法
  • 原文地址:https://www.cnblogs.com/quanweiru/p/8573025.html
Copyright © 2020-2023  润新知