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 ..... 原文链接：https://www.f2er.com/oracle/207587.html