SQL Logins, and the databases they have access to.

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. 

 

Related Articles

... and you 'll find more on the SQL (Dynamics) Menu

 

CREATE TABLE _LoginDBMapping (
    LoginName nvarchar(max),
    DBname nvarchar(max),
    Username nvarchar(max),
    AliasName nvarchar(max)
)
INSERT INTO _LoginDBMapping
EXEC master..sp_msloginmappings

 

 

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences