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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------