OraFAQ Forum: Security » automatic password expiration ?

Home » RDBMS Server » Security » automatic password expiration ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

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:

Code: [Select all] [Show/ hide]

CREATE PROFILE your_profile LIMIT
  FAILED LOGIN ATTEMPTS 3
  PASSWORD_LIFE_TIME 30; -- 30 days life time of a password

afterwards you assign the profile to a user:

Code: [Select all] [Show/ hide]

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.

HTH,

MHE

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 16 22:43:44 CDT 2025