ORACLE用户profiles

1 创建概要文件test_profiles

create profile test_profile limit
sessions_per_user unlimited
cpu_per_session unlimited
cpu_per_call 3000
connect_time 45
logical_reads_per_session default
logical_reads_per_call 1000
private_sga 15k
composite_limit 5000000;

2 创建概要文件profile_password（该文件用户设定用户的口令策略）

create profile profile_password limit
failed_login_attempts 5
password_life_time 60
password_reuse_time 60
password_reuse_max 5
password_lock_time 1/24
password_grace_time 10;

 

3 修改用户的概要文件：

alter user icdpub profile test_profile;

 

4 删除概要文件：

drop profile test_profile cascade;