dba_users中的ACCOUNT_STATUS列说明

 

1. open 当前用户是开放的可以使用的.

2. expired 表示用户已经过期, 登录的时候, 如果密码输入正确,系统会提示重新输入密码的.

3. locked 表明当前帐户被锁了, 不可以登录的.

expired (grace)  与 locked (timed) 是有系统的profile来进行控制的.

4. expired (grace) 指定一个期限, 到达这个期限的时候,系统会给出一个警告并且允许登录(grace), 如果过了这段期限, 对应的密码就会自动过期, 相当于我们的密码过期提醒.PASSWORD_GRACE_TIMEPASSWORD_LIFE_TIMESpecify the number of days after the grace period begins during which a warning is issued and login is allowed. If the password is not changed during the grace period, the password expires.

5. locked(timed)PASSWORD_LOCK_TIMESpecify the number of days an account will be locked after the specified number of consecutive failed login attempts.FAILED_LOGIN_ATTEMPTSSpecify the number of failed attempts to log in to the user account before the account is locked.设定相关的profile属性^_^.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7728585/viewspace-524758/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7728585/viewspace-524758/