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)
8,695 reads
Mani Singh,
2008-07-29 (first published: 2008-06-08)
Another documented SP, which is useful for tracking Quick Login Info.
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
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
8,695 reads
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,618 reads
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.
This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.