`

(14) Managing Password Security and Resources

阅读更多
  • Password Management

    SQL> alter user xxx account lock(unlock)      显示锁定用户

    SQL> alter user xxx password expire

    SQL> create profile profile1 limit

              failed_login_attempts  3

              password_lock_time 1/1440; (单位是天)

    SQL> alter user xxx profile profile1;

    FAILED_LOGIN_ATTEMPTS

    PASSWORD_LOCK_TIME

  • Password Expiration and Agin

          PASSWORD_LIFE_TIME

          PASSWORD_GRACE_TIME

          SQL>alter profile profile1 limit

                  password_life_time 2

                  password_grace_time 1

  • Password History

          PASSWORD_REUSE_TIME    (时间)

          PASSWORD_REUSE_MAX    (次数)    

  • Password Verification

          PASSWORD_VERIFY_FUNCTION         

Oracle默认VERIFY_FUNCTION,利用script(SYS)创建这个函数,同时会修改default的profile

script:utlpwdmg.sql

  • Dropping a Profile

    SQL> drop profile xxx cascade

  • Resource Management

          SQL> alter system set resource_limit=true (使生效) RESOURCE_LIMIT

  • Setting Resource Limits at Call Level

          CPU_PER_CALL

          LOGICAL_READS_PER_CALL

  • Database Resource Manager

           (1) Resource consoumer group

           (2) Resource plan

           (3) Resource allocation method

           (4) Resource plan directives

            DBMS_RESOURCE_MANAGER package

            需要权限:ADMINISTER_RE

  • DBA_USER   DBA_PROFILES
分享到:
评论
发表评论

文章已被作者锁定,不允许评论。

相关推荐

    oracle里的常用命令

    日志管理 ,表空间管理 ,表管理,索引管理,约束,LOAD数据,reorganizing data,managing password security and resources,Managing users ,managing privileges等

    oracle命令(doc)

    1.oracle里的常用命令 ...(8)managing password security and resources (9)managing users (10)managing privileges (11)managing role (12)backup and recovery 2.solaris下oracle的操作命令

    oracle命令全集

    - **第八章:managing password security and resources** 用户密码策略、资源限制和审计。 - **第九章:Managing users** 创建、修改和删除用户,以及授权。 - **第十章:managing privileges** 授予和撤销用户权限...

    Exchange Server 2010 Administration

    - **Implementing Strong Authentication:** Using multi-factor authentication and strong password policies to prevent unauthorized logins. - **Securing Network Traffic:** Enforcing secure protocols such...

    BSD Hacks.pdf

    19. **Creating an Effective, Reusable Password Policy (HACK 31):** Guidelines for developing and implementing a robust password policy that balances security with usability. 20. **Automating ...

    python3.6.5参考手册 chm

    PEP 466: Network Security Enhancements for Python 2.7 Acknowledgements What’s New in Python 2.6 Python 3.0 Changes to the Development Process New Issue Tracker: Roundup New Documentation Format: ...

    Cisco Press - OSPF Network Design Solutions, 2nd Edition

    Chapter 8 Managing and Securing OSPF Networks 441 Chapter 9 Troubleshooting OSPF 533 Chapter 10 BGP and MPLS in an OSPF Network 655 Part IV Additional OSPF Resources 707 Appendix A OSPF RFCs 705 Index...

    oa源码 大型oa asp.net 源码

    - **Mr**: A class likely containing methods for managing user sessions and authentication. - **iOfficeData.Res**: A class for resource management. - **iofficeservice.sysSet**: A class for accessing ...

    TMS320F28335

    - **Implementations**: Password protection, secure boot, and encryption capabilities. #### 4. Peripheral Components ##### 4.1 DMA Overview - **Description**: Direct Memory Access (DMA) controller ...

    php.ini-development

    Turning on this setting and managing its maximum buffer size can yield some ; interesting side-effects depending on your application and web server. ; You may be able to send headers and cookies ...

    最完整的Toad For Oracle使用手册

    - **Additional Resources**:提供额外的学习资源链接,帮助用户深入学习Toad的相关知识。 #### 四、与其他Quest产品的协作 - **Working with other Quest Products**:探讨了Toad如何与Quest的其他产品协同工作,...

Global site tag (gtag.js) - Google Analytics