Password Change @ Initial login

I think this topic has been covered before, but I can't find the thread. Is there a way to force users to change their password on their initial signon? I've been giving users passwords with a random mix of 5 letters and numbers hoping that they would rather change their password than memorize the random one. Thanks.

Hi there :

Yes, open the F98OWSEC table, change your user's periodicity to let's
say SCSECFRQ = 45 (days), and change SCSECLST to a date older than 45
days ago (such as 01/01/2001).
Next time that user logs in will be invited to change the password.

Regards, Sebastian Sajaroff

The only way I know of is to set their password expiration to < 5 days so
that they are prompted with a "your password will expire in x days..." to
get them to change it. The only thing is that when they change it you
then have to go back in and reset their password expiration to 90 days (or
whatever your company uses). It's fairly time consuming for the Admin to
have to go in to everybody's profile twice.

File F98OWSEC in data source SYS7333 includes field SCSECLST which tells
you when the person changed their password last. This field is in Julian
format. Perhaps a daily query to see if anyone needs to change their
password accompanied by a nagging e-mail? Just a thought.

Regards,
Gerald.






njcncadmin
<[email protected]> To: Gerald Kastanek/Toronto/IBM@IBMCA
Sent by: cc:
owner-jdelist@jde Subject: Password Change @ Initial login
list.com


11/05/2002 05:37
PM
Please respond to
jdelist





I think this topic has been covered before, but I can't find the thread.
Is there a way to force users to change their password on their initial
signon? I've been giving users passwords with a random mix of 5 letters
and numbers hoping that they would rather change their password than
memorize the random one. Thanks.
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=44662
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

Re: RE: Password Change @ Initial login

Works like a charm. Thank you.

We do this through a Oracle procedure. The SQL to expire a password
immediately is shown below...

UPDATE sysb733.f98owsec
SET scupmj = 100001, scseclst = 100001
WHERE scuser = 'WHATEVER_USER_ID';

COMMIT;

You can do this manually or build a procedure where all you have to do is
pass the user ID.

Regards,
Tony Nelipovich
B7331
Oracle 8.1.6.3