SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server.
Update to Simon Facer's script.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.91 (11)

You rated this post out of 5. Change rating

2011-05-23 (first published: 2007-09-25)

13,377 reads

Blogs

If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...

https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...

We get it. There’s no budget for a DBA on staff, or even a...

Forums

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...

Hello SSC, I am not sure if I posted this in the right spot,...

What is a partial backup for a read-write database?