Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle users and password changes
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DIANNA GIBBS
Sent: Wednesday, April 04, 2007 9:49 AM
To: oracle-l_at_freelists.org
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.
Thanks.
Dianna G.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 04 2007 - 11:32:50 CDT