如果商业环境发生了变化,概要文件中的参数设置已经不合时宜了,可以使用
alter profile语句修改这些限制。
如下:
SQL> alter profile unluck_prof limit
2 failed_login_attempts 4
3 password_life_time 74
4 password_grace_time 14;
Profile altered.
SQL> select * from dba_profiles
2 where profile like 'UNLUCK%'
3 and resource_type='PASSWORD';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------- -------- --------------------
UNLUCK_PROF FAILED_LOGIN_ATTEMPT PASSWORD 4
S
UNLUCK_PROF PASSWORD_LIFE_TIME PASSWORD 74
UNLUCK_PROF PASSWORD_REUSE_TIME PASSWORD 24
UNLUCK_PROF PASSWORD_REUSE_MAX PASSWORD DEFAULT
UNLUCK_PROF PASSWORD_VERIFY_FUNC PASSWORD DEFAULT
TION
UNLUCK_PROF PASSWORD_LOCK_TIME PASSWORD UNLIMITED
UNLUCK_PROF PASSWORD_GRACE_TIME PASSWORD 14
7 rows selected.
SQL> select * from dba_profiles
2 where resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------- -------- --------------------
DEFAULT FAILED_LOGIN_ATTEMPT PASSWORD 3
S
MONITORING_PROFILE FAILED_LOGIN_ATTEMPT PASSWORD UNLIMITED
S
LUCK_PROF FAILED_LOGIN_ATTEMPT PASSWORD DEFAULT
S
UNLUCK_PROF FAILED_LOGIN_ATTEMPT PASSWORD 4
S
使用drop 命令删除无用的概要文件:
SQL> drop profile luck_prof;
Profile dropped.
或
SQL> drop profile unluck_prof cascade;
Profile dropped.
查询是否删除:
SQL> select * from dba_profiles
2 where resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------- -------- --------------------
DEFAULT FAILED_LOGIN_ATTEMPT PASSWORD 3
S
MONITORING_PROFILE FAILED_LOGIN_ATTEMPT PASSWORD UNLIMITED
S
alter profile语句修改这些限制。
如下:
SQL> alter profile unluck_prof limit
2 failed_login_attempts 4
3 password_life_time 74
4 password_grace_time 14;
Profile altered.
SQL> select * from dba_profiles
2 where profile like 'UNLUCK%'
3 and resource_type='PASSWORD';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------- -------- --------------------
UNLUCK_PROF FAILED_LOGIN_ATTEMPT PASSWORD 4
S
UNLUCK_PROF PASSWORD_LIFE_TIME PASSWORD 74
UNLUCK_PROF PASSWORD_REUSE_TIME PASSWORD 24
UNLUCK_PROF PASSWORD_REUSE_MAX PASSWORD DEFAULT
UNLUCK_PROF PASSWORD_VERIFY_FUNC PASSWORD DEFAULT
TION
UNLUCK_PROF PASSWORD_LOCK_TIME PASSWORD UNLIMITED
UNLUCK_PROF PASSWORD_GRACE_TIME PASSWORD 14
7 rows selected.
SQL> select * from dba_profiles
2 where resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------- -------- --------------------
DEFAULT FAILED_LOGIN_ATTEMPT PASSWORD 3
S
MONITORING_PROFILE FAILED_LOGIN_ATTEMPT PASSWORD UNLIMITED
S
LUCK_PROF FAILED_LOGIN_ATTEMPT PASSWORD DEFAULT
S
UNLUCK_PROF FAILED_LOGIN_ATTEMPT PASSWORD 4
S
使用drop 命令删除无用的概要文件:
SQL> drop profile luck_prof;
Profile dropped.
或
SQL> drop profile unluck_prof cascade;
Profile dropped.
查询是否删除:
SQL> select * from dba_profiles
2 where resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------- -------- --------------------
DEFAULT FAILED_LOGIN_ATTEMPT PASSWORD 3
S
MONITORING_PROFILE FAILED_LOGIN_ATTEMPT PASSWORD UNLIMITED
S