This article describes how to create user defined server roles and use stored procedures and queries related.  Read more...

SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.  Read more...

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.  Read more...

Having flown a fair amount lately, I was thinking about the various levels of security within an airport.  Part of...  Read more...

Scripts role membership, object-level permissions for all DB users.  Read more...

Scripts role membership, object-level permissions for all DB users.  Read more...

This script basically retreives all database users thier database roles for a database.   Read more...