sql server list user permissions
-- SQL Server: list of users and roles SELECT dp.NAME AS principal_name, dp.TYPE_DESC AS principal_type_desc, o.NAME AS object_name, p.PERMISSION_NAME, p.STATE_DESC AS permission_state_desc FROM sys.database_permissions p LEFT OUTER JOIN sys.all_objects o ON p.MAJOR_ID = o.OBJECT_ID INNER JOIN sys.database_principals dp ON p.GRANTEE_PRINCIPAL_ID = dp.PRINCIPAL_ID;