User Log on


Active Member

Is there a way to force users change their password when they log on for the
first time ? something like NT

NT, SQL7.0,Xe sp13 u2



Legendary Poster
Hi Javid,

As far as I know, you can set only the password change frequency in days.


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)


Well Known Member

The only method I've found is to set the date back to eariler than 90 days
(or whatever your expiration period is) on the PC when creating the profile
or when re-setting the users password. Its not pretty but it works.

/ Ian

Xe, Oracle 8, NT


Well Known Member
This works on the AS/400 but I'm not sure if it applies to all server types.

Make the necessary password change in the user profile.
at the command line got to sql (STRSQL)
at the SQL command line enter the following;

update sysb733/f98owsec
set scupmj = 100001, scseclst = 100001
where scuser = 'KIRSCHBAS'

This expires the password so that the user is requested to enter a new
password the first time they logon. Keeps fingers from pointing to I.S.
about knowing everyones password.


AS/400 V4R4 B7332 SP11.3
Call Orchestrations From Excel – The Easy Way to Make the Orchestrator Work for You.


You can do it but it's "custom".

There is a field in the F98OWSEC Alias is SECLST.

When we create a new user we default the days to expire to 90.

Then we manually set the security last checged date to 91 days ago.

Any developer could easily put that logic on an exit bar button off the user
security application.

Dan Eppich

B7332 Coex 720/V4R5 Citrix/Fat


Legendary Poster
Hi Ian,
Not pretty but tricky. You made me an idea.
My developer approach is to investigate the security application with FDA to figure out where and how the expiration is strored and make a little custom application or mods in the security application which modifies this date stamp.


Oooops! I just read throughout the thread and see that Dan already had posted this answer, moreover he pointed out the table and field too. OK, next time I will read through out the entire thread before I reply.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)<P ID="edit"><FONT SIZE=-1>Edited by Zoltan_Gyimesi on 8/10/01 10:01 AM.</FONT></P>