Another documented SP, which is useful for tracking Quick Login Info.
Script DB Level Permissions v4.3
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
13,622 reads
show users in NT Groups
xp_logininfo --This will give you a list of all Account Names on SQL Server instance xp_logininfo '<Group or Login>' xp_logininfo 'SQL Administrators' --This will List the acount information xp_logininfo 'SQL Administrators','members' --This will List all the available users in the Group with Mapped Login names
Related content
Grant Permission to Specific objects(e.g. SP's)
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,626 reads
Database User Superfluousness In SQL Server
In this article, Thomas Knight analyzes and critiques the design of, and experience with, the "dual-level" user security in SQL Server. He then demonstrates a better theoretical alternative.
2014-02-04
4,273 reads
Query accounts, domain groups, and members who have admin membership.
This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.
2012-02-09
6,658 reads