Re: Password change

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/12/31
Message-ID: <34aa7b43.5939029@inet16>#1/1

On Tue, 30 Dec 1997 11:11:28 +0100, "Reinier Muller" <reinier.muller_at_consunet.nl> wrote:

>We currently use RACF at the mainframe to set password expiration methods.
>We are about to move our Oracle Databas from the mainframe to AIX (IBM's
>UNIX). Does anyone know a way or package that forces the end-users to change
>their password after a certain period?
>
>Regards,
>Reinier Muller
>Senior System Engineer R&D
>

With Oracle8 you can do this pretty easily in the database. With Oracle7, you could use OS authentication and password aging supplied by the OS.

In Oracle8, you can:

create profile age
limit
password_life_time 30
password_grace_time 5
/

alter user scott profile age
/

That would make it so that passwords must be changed every 30 days and starting on the 25'th day, users would be warned that their password is due to expire.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Dec 31 1997 - 00:00:00 CST