修改和删除概要文件

来源：互联网发布：手机淘宝店招尺寸2017 编辑：程序博客网时间：2024/05/22 08:21

如果商业环境发生了变化，概要文件中的参数设置已经不合时宜了，可以使用
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