User Log on

[javidahmad]

Hello,

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

Javid

 

[Zoltan_Gyimesi]

Hi Javid,

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

Zoltán

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

 

[ijc]

Javid

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

 

[AllisonD]

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.

Darrell

AS/400 V4R4 B7332 SP11.3

 

[daneppich25]

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

 

[Zoltan_Gyimesi]

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.

Zoltán

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>