Know your gear
Idera SQLsecure helps you eliminate security holes and verify your SQL Server security model. SQLsecure does this by performing rights analysis across SQL Server, Active Directory and Windows and calculating the effective access rights for any user, object or access control. With SQLsecure, not only can you view the effective rights of particular users or groups, but you can also select an individual database object, and see who has what rights on that particular object, and how those rights were granted. SQLsecure also allows you to assess changes made to access rights so you can easily remediate unwanted changes. In addition to rights analysis, SQLsecure also collects and evaluates security settings within SQL Server, and provides recommendations to improve server security.