Community

SQL Server Permissions List for Read and Write Access for all Databases

(Pablo Echeverria) For compliance auditing, a customer asked for a list of users who have read or write access in any database on the SQL Server instance. Although there are several tables that can provide us the information, the permissions can be at the instance level or at the individual database