Home » RDBMS Server » Security » automatic password expiration ?
automatic password expiration ? [message #13245] Thu, 01 July 2004 12:14 Go to next message
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 Go to previous message
Messages: 7064
Registered: December 2001
Senior Member
Yes you can. You create a profile using this syntax:
  PASSWORD_LIFE_TIME 30; -- 30 days life time of a password
afterwards you assign the profile to a user:
ALTER USER some_user PROFILE your_profile;
A full explanation can be found in your Database Administrator's Guide. Here's a direct link (needs a free subscription to OTN).

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.


Previous Topic: can not populate audit log table
Next Topic: what is the diff. between Rights and Privilages
Goto Forum:

Current Time: Sat Jan 28 08:03:20 CST 2023