lundi 9 février 2015

SQL logins Audit for SQL Server 2005/2008


For the Security Audit of SQL servers 2005/8 R2,


We are looking for a method which can list us SQL accounts which have not changed password for last X days. For a single login we can do it via LastSetTime in Loginproperty. But for many servers there are more than 80 logins. How should we extract this information for existing logins?


Also, for those we found who have not changed password in last X days, I believe we need to have existing password. Now the problem is, that existing password cannot be found as was set up way back and password change policy was not marked. What should we do in such cases?


Thanks!





Aucun commentaire:

Enregistrer un commentaire