ORACLE_基础十二(Profiles)

Profiles

1.A pfofile is a named set of password and resource limits

2.Profile are saaigned to users by the CREATE USER or ALTER USER command

3.Profiles can be enabled or disabled

4.Profiles can relate to the DEFAULT profile.

Password Management

Enabling  Password Mgmt

1.Set up password management by using profiles and assigning them to users

2.Lock unlock,and expire accounts using the CREATE USER or ALTER USER command

3.Password limits are always enforced

4.To enable password management,run utlpwdmg.sql script as the user SYS.

Profiles Parameter

FAILED_LOGIN_ATTEMPTS: Number of failed login attempts before loackout of the account

PASSWORD_LOCK_TIME: Number of days the account is locked after the specified number of failed login attempts

PASSWORD_LIFE_TIME: Lifetime of the password in days after which the password expires

PASSWORD_GRACE_TIME: Grace period in days for changing the password after the first successful login after   

                                               the password has expired

PASSWORD_REUSE_TIME: Number of days before a password can be reused

PASSWORD_REUSE_MAX :Maximum number of changes required before a password can be reused

PASSWORD_VERIFY_FUNCTION: PL/SQL function that performs a password complexity check before

                                                              password is assigned

Use-Provided Passwd Func