How do I determine the security group through which a user is granted permission?

[Rayford kinney]

Hi all,

In SQL Server, a user in my domain is able to access a database because they are a member of a particular security group. How can I determine the security group that this user is a member of and therefore is gaining access?

Thanks a lot.
Rayford

 

[office politics]

try this

SQL Server Security Audit Report