Oracle用户安全及用户资源限制文件

1、新建资源限制文件
SQL> create profile luck_porf limit
  2  session_pre_user 8
  3  cpu_pre_user 16800
  4  logical_reads_per_session 23688
  5  connect_time 268
  6  idle_time 38;

2、口令限制文件新建
SQL> create profile unluck_prof limit
  2  failed_loging_attempts 7
  3  password_lock_time unlimited
  4  password_life_time 44
  5  password_reuse_time 24
  6  password_grace_time 4;

3、综合使用
SQL> create profile pioneer_prof limit
  2  failed_login_attempts 4
  3  password_lock_time unlimited
  4  password_life_time 91
  5  password_reuse_time 28
  6  password_grace_time 7
  7  sessions_per_user 3
  8  cpu_per_session 16800
  9  logical_reads_per_session 23688
 10  connect_time 180
 11  idle_time 28;

4、赋予用户
  create user ||  alter user .....