on 07-22-2017 12:03 PM
Dear Support Team,
I have 100+ Sybase ASE data servers where the password of a certain login has expired due to the password expiration interval set to 90.
I am going to set the password expiration interval to 0 so they never expire again but is it possible somehow to "unexpire" these expired passwords so I do not have to provide a new one to each one of them but continue using the old value?
Thanks in advance.
Regards,
Laszlo
Yes.
1. Alter the login to give it a longer password expiration interval or no expiration at all:
alter login login_name modify password expiration 0
go
2. Manually turn off the syslogins bit that indicates the login has an expired password
(this bit is set on the first time the user tries to login after the password has expired)
use master
go
update syslogins
set status = status ^ 4
where status & 4 = 4
and name = <login_name>
go
checkpoint
go
-bret
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Excellent idea, thanks a lot Bret.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.