RE: user password expire

Whoa, that's WAY more complicated than it needs to be. If you need me to, I can look up the exact syntax of the commands, but DBMS_JOB does NOT need to be involved here. If you need to expire users passwords after a set amount of time, on Oracle8x you can setup profiles that will allow you to set what the password expire time period is, and password history tracking, so that users cant use the same password over and over resetting it to the same thing. It takes care of it all through profiles. If you look into setting up profiles it should shed a lot more light on this for you, and again, if you need more info/help with this, or can't find the information, let me know and I can look it up....I know I have it here somewhere, just can't remember exactly where I read it before.

-::YEX::-
<)))><

-----Original Message-----
From: Jamadagni, Rajendra [mailto:rajendra.jamadagni_at_espn.com] Sent: Tuesday, November 28, 2000 11:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: user password expire

Lisa

This is from my 8i Release 2 Doco ...

The following statement causes user FRED's password to expire:

ALTER USER fred PASSWORD EXPIRE;

If you cause a database user's password to expire with PASSWORD EXPIRE, the user (or the DBA) must change the password before attempting to log in to the database following the expiration. However, tools such as SQL*Plus allow you to change the password on the first attempted login following the expiration.

Note: Oracle expects a different timestamp for each resetting of a particular password. If you reset one password multiple times within one second (for example, by cycling through a set of passwords using a script), Oracle may return an error message that the password cannot be reused. For this reason, Oracle Corporation recommends that you avoid using scripts to Received on Tue Nov 28 2000 - 11:28:25 CST