-
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