RE: Automatic password expiration

From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
Date: Tue, 9 Mar 2004 01:03:06 -0700
Message-ID: <87E9F113CEF1D211A4C3009027301874195D05@ddbcinc.ddbc.local>

Generally, the easiest way to do this is to create a profile which puts a limit on PASSWORD_LIFE_TIME and then assign users that profile. The Oracle Administrator's Guide has a section on setting this up.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/secure.htm#2185

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Monday, March 08, 2004 12:25 PM
To: Oracle-L (E-mail)
Subject: Automatic password expiration

The 8.1.7 Administrator's Guide suggests that the DBA should force users to change their passwords periodically. I cannot, however, find command in the SQL Reference which automates this function. Am I missing something?

Thanks,
Peter Schauss

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Mar 09 2004 - 01:56:16 CST