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

  • 相关阅读:
    Java POI Word 写文档
    安装SQL Server Management Studio遇到的29506错误
    DataSet中的relation
    如何在Eclipse中配置Tomcat
    button与submit
    redis应用场景
    机器学习实战-KNN(K-近邻算法)详解
    python中的random扩展
    php函数实现文章列表显示的几秒前,几分钟前,几天前等方法
    HTML5的Video标签的属性,方法和事件汇总
  • 原文地址:https://www.cnblogs.com/quanweiru/p/8573025.html
Copyright © 2020-2023  润新知