(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