RE: Oracle users and password changes

  • From: "Smith, Steven K - MSHA" <Smith.Steven@xxxxxxx>
  • To: <DIANNA.GIBBS@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 4 Apr 2007 10:32:50 -0600

Dianna - 

Oracle can manage password expiring through the use of profiles.  The
expire date is stored in the dba_users table.  You can set up a job to
search that table and send out emails to users telling them that their
passwords is expired or about to expire and to change it.  

Otherwise, using profiles, you can have them expire every 90 days and
notify them the next time they log on to change their passwords.

Steve Smith
Desk: 303-231-5499

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DIANNA GIBBS
Sent: Wednesday, April 04, 2007 9:49 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle users and password changes

We need to set up a process where Oracle
users (currently few and mostly ODBC using Access) are notified and can
change their password dynamically every 90 days.

We were wondering what other companies do and any
best practices?  Any thoughts or comments appreciated.

Dianna G.


Other related posts: