Removing password expiration for one user

[Raymond_Mardle]

Folks,
I need to remove the password expiration setting for one user. The user
did not have an individual setting until I used sp_modifylogin when testing
the individual setting. I assumed that I would be able to remove it by
specifying a value of "-1" but the ASE (12.5.0.3 on NT) reports this as an
invalid value. I have set it to zero but this now ignores the system wide
configuration setting.

I don't want to use "all overrides" to remove everyone's setting of
password expiration and I'd rather not do a manual delete of the row from
sysattributes if there is another way to do this.

sp_modifylogin does not appear to cater for removing any changed
attributes (for instance, fullname cannot be reset back to NULL).

Ta muchly in advance

Raymond

[Ramon Vennik]

create a login trigger for this user/all users and let this trigger check
the expiration date in a (to be created user table where you store
suid/expiration_date).
this trigger performs a syb_quit() when getdate() > expiration_date and the
session will terminate itself.

Ramon

<Raymond_Mardle> wrote in message
news:8B6B465DFDF495C60033680F85256D2F.0033682C85256D2F@webforums...

[David_Velasco]

Have you tried this ?

sp_modifylogin "joe", @option="passwd expiration", @value="0"

Well i havent tried it myself (ill give it a shoot soon) but what i did
was and update to syslogins :

update syslogins
set pwdate="to something like 20 years from now"
where name = "login name"

The only inconvient that i have found so far (besides the update to a
system table) is that i need to update the pwdate to that value "way far in
the future" everytime i change the password for "login name".

[Raymond_Mardle]

David,
That sp_modifylogin with a value of zero is what I did to get myself into
this problem. It puts a row in sysattributes and it is that row that is
causing the problem. Using "all overrides" with a value of -1 deletes all
the rows for password expiration from sysattributes for all users but there
doesn't appear to be a way to do it for a single user. I was wondering if I
could remove the row without resorting to a manual delete from
sysattributes.

Cheers

Raymond

[Russ Allen]

Enable allow updates and set the value of the syslogins.pwdate column
for the user to a date way out in the future. Be aware, that if the user
changes their password at a later date, you will need to reset the
value. You could alter sp_password to look up a list of users whose
password is not to expire from a table and set the pwdate column accoringly.

Russ