stevegray
4Penny.net
Points: 53175

5/10/2018 11:28:05 AM

SQL Logins, and the databases they have access to.

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

I ran across this gem today, though I'd blog it before I lost it. 

This script will create a table of all SQL Logins, and the DBs that the logins have access to. 

 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3