| automatic password expiration ? [message #13245] |
Thu, 01 July 2004 12:14  |
Dharan Sakthi
Messages: 3
Registered: May 2002
|
Junior Member |
|
|
|
How do you expire passwords for users in oracle automatically. I would like to expire all passwords after 30 days of use. Is there a way to achieve this automatically. Thanks in advance.
|
|
|
|
| Re: automatic password expiration ? [message #13251 is a reply to message #13245] |
Thu, 01 July 2004 21:39  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
Yes you can. You create a profile using this syntax:
CREATE PROFILE your_profile LIMIT
FAILED LOGIN ATTEMPTS 3
PASSWORD_LIFE_TIME 30; -- 30 days life time of a password ALTER USER some_user PROFILE your_profile;
Password options for a profile are:
- FAILED_LOGIN_ATTEMPTS: number of times a user can provide an incorrect password.
- PASSWORD_LIFE_TIME: number of days the same password can be used for authentication.
- PASSWORD_REUSE_TIME: number of days before which a password cannot be reused.
- PASSWORD_REUSE_MAX: number of password changes required before the current password can be reused.
- PASSWORD_LOCK_TIME: number of days an account will be locked after the specified number of consecutive failed login attempts.
- PASSWORD_GRACE_TIME: number of days after the grace period begins during which a warning is issued and login is allowed.
- PASSWORD_VERIFY_FUNCTION: lets a PL/SQL password complexity verification script be passed as an argument to the CREATE PROFILE statement. Oracle provides a default script, but you can create your own routine or use third-party software instead.
I suggest you read the docs because some restrictions apply.
HTH,
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
