Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Richard Doering,
A script to reveal which logins have access to your sql server via windows groups.
If you use Windows Authentication and have Windows groups as logins this script can help.It reveals members of Windows groups and their Server permissions.
This is particularly handy if you're not the network administrator or dont have access to the Active Directory tools.
Hope it helps someone...
Database acces windows group
Windows users mapped to SQL Groups
If a windows user is part of two distinct windows groups and
How to block windows AD groups from connecting to SQLServer 2005 and Kill existing connections
Using Windows group instead of single Windows account to connect to another SQL Server via link