Is there a way to find out if a user has not changed his/her passord in more than 90 days. I need to find the date of last password change and days since last password changes.
Thanks in Advance.The only way that I know to do this is to create a table with three columns, one for the login name, one for the current (hashed) password, and one for the date the last change was detected. Periodically (probably daily) check to see if there are either new logins or new password values.
-PatP|||Well, I wouldn't say that that's the only way. In fact, all you need is 2 columns, login and lastchanged. I've gone a little further and modified 3 system procedures, - sp_password, sp_addlogin, and sp_droplogin by implementing password aging and compexity. By having the table above you can incorporate UPDATE, INSERT, and DELETE into/from it respectively.|||You've got a point, but modifying system supplied stored procedures or triggers will get you a reserved seat in the "naughty" section in my opinion. I wouldn't consider recommending that, and probably wouldn't permit it in any environment that I can control.
-PatP|||Just use trusted connections|||You've got a point, but modifying system supplied stored procedures or triggers will get you a reserved seat in the "naughty" section in my opinion. I wouldn't consider recommending that, and probably wouldn't permit it in any environment that I can control.
-PatPThere are no system triggers. Modifying system stored procedures? If you know what you're doing, and if your Change Management process is in place, - I see no problem with that. After all, it's those modifications that prompted Yukon development team to implement...well, you'll see it in the next CTP.|||Come on...you can say it....
Better yet, if you're interested download 2005 BOL|||Too much inaccurate info there. It hasn't matched a single Beta-2 built yet ;)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment