VirtualObjectives

Logins Audit

This script allows you to audit logins on your SQL Servers. It produces three tables of data which can be displayed as query results or emailed to you:

Access by Database

Access by Role

Access by User


Requirements:

  • SQL Server 2005 and above.
  • If using the email option:
    • Database Mail set up
    • Requires SaveTableAsHTML
    • Requires xp_cmdshell enabled

Download/Script:

Download Logins_Audit.zip

Acknowledgments:

  • Randy Dyess for store procedure spRoleMembers.