SQL Server query to find all permissions/access for all users in a database
This is my first crack at a query, based on Andomar’s suggestions. This query is intended to provide a list of permissions that a user has either applied directly to the user account, or through roles that the user has. /* Security Audit Report 1) List all access provisioned to a sql user or windows … Read more