SQL：用户当前Profile的设置清空
Code：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 |
SQL> col profile for a18 SQL> col limit for a32 SQL> set linesize 300 SQL> select profile,resource_name,resource_type,limit from dba_profiles order by profile,resource_type; PROFILE RESOURCE_NAME RESOURCE LIMIT ------------------ -------------------------------- -------- -------------------------------- DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED DEFAULT CPU_PER_CALL KERNEL UNLIMITED DEFAULT CPU_PER_SESSION KERNEL UNLIMITED DEFAULT PRIVATE_SGA KERNEL UNLIMITED DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED DEFAULT IDLE_TIME KERNEL UNLIMITED DEFAULT CONNECT_TIME KERNEL UNLIMITED DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10 DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 ORA_STIG_PROFILE COMPOSITE_LIMIT KERNEL DEFAULT ORA_STIG_PROFILE SESSIONS_PER_USER KERNEL DEFAULT ORA_STIG_PROFILE PRIVATE_SGA KERNEL DEFAULT ORA_STIG_PROFILE CONNECT_TIME KERNEL DEFAULT ORA_STIG_PROFILE IDLE_TIME KERNEL 15 ORA_STIG_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT ORA_STIG_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT ORA_STIG_PROFILE CPU_PER_CALL KERNEL DEFAULT ORA_STIG_PROFILE CPU_PER_SESSION KERNEL DEFAULT ORA_STIG_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD ORA12C_STRONG_VERIFY_FUNCTION ORA_STIG_PROFILE PASSWORD_REUSE_MAX PASSWORD 10 ORA_STIG_PROFILE PASSWORD_REUSE_TIME PASSWORD 365 ORA_STIG_PROFILE PASSWORD_LIFE_TIME PASSWORD 60 ORA_STIG_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD 3 ORA_STIG_PROFILE PASSWORD_LOCK_TIME PASSWORD UNLIMITED ORA_STIG_PROFILE PASSWORD_GRACE_TIME PASSWORD 5 32 rows selected. SQL> SQL> alter profile ORA_STIG_PROFILE limit PASSWORD_REUSE_MAX 20; Profile altered. SQL> select profile,resource_name,resource_type,limit from dba_profiles order by profile,resource_type; PROFILE RESOURCE_NAME RESOURCE LIMIT ------------------ -------------------------------- -------- -------------------------------- DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED DEFAULT CPU_PER_CALL KERNEL UNLIMITED DEFAULT CPU_PER_SESSION KERNEL UNLIMITED DEFAULT PRIVATE_SGA KERNEL UNLIMITED DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED DEFAULT IDLE_TIME KERNEL UNLIMITED DEFAULT CONNECT_TIME KERNEL UNLIMITED DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10 DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 ORA_STIG_PROFILE COMPOSITE_LIMIT KERNEL DEFAULT ORA_STIG_PROFILE SESSIONS_PER_USER KERNEL DEFAULT ORA_STIG_PROFILE PRIVATE_SGA KERNEL DEFAULT ORA_STIG_PROFILE CONNECT_TIME KERNEL DEFAULT ORA_STIG_PROFILE IDLE_TIME KERNEL 15 ORA_STIG_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT ORA_STIG_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT ORA_STIG_PROFILE CPU_PER_CALL KERNEL DEFAULT ORA_STIG_PROFILE CPU_PER_SESSION KERNEL DEFAULT ORA_STIG_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD ORA12C_STRONG_VERIFY_FUNCTION ORA_STIG_PROFILE PASSWORD_REUSE_MAX PASSWORD 20 ORA_STIG_PROFILE PASSWORD_REUSE_TIME PASSWORD 365 ORA_STIG_PROFILE PASSWORD_LIFE_TIME PASSWORD 60 ORA_STIG_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD 3 ORA_STIG_PROFILE PASSWORD_LOCK_TIME PASSWORD UNLIMITED ORA_STIG_PROFILE PASSWORD_GRACE_TIME PASSWORD 5 32 rows selected. SQL> |
——————————————————————————————
Ending。
