Oracle Profile Usage Tips

Assigning a profile requirement to Scott users is as follows:

1, try to log in the number of times up to 4 times;

2, if 4 times the input error, then lock the user for 2 days;

3, the password is modified every 5 days, the grace period is 2 days;

For:

Sql>conn SYS/ORCL as SYSDBA;

Sql>create profile Scottprofile Limit failed_login_attempts 4 password_lock_time 2 password_life_time 5 Password_ Grace_time 2;

Sql>alter user Scott profile Scottprofile;

Oracle Profile Usage Tips