Script to get all logins and database user mappings

• uncle_enzo

  Mr or Mrs. 500

  Points: 573

  More actions

  July 22, 2009 at 1:00 pm

  #103787

  I need to collect all logins and user database mappings. I looked at master and found login names and default database mappings but I don't see what databases the login is a user in. What I would really like is to have a query that gives login name user databases it has access to and the database role.

  Is this possible?

  Thanks

• kladibeeto

  SSCommitted

  Points: 1582

  More actions

  July 28, 2009 at 11:59 am

  #1031218

  Hi,

  Try with

  sp_helplogins

  sp_helpuser

• uncle_enzo

  Mr or Mrs. 500

  Points: 573

  More actions

  July 28, 2009 at 3:39 pm

  #1031371

  Thanks, I forgot about these.

• kladibeeto

  SSCommitted

  Points: 1582

  More actions

  July 28, 2009 at 3:54 pm

  #1031376

  It's my pleasure

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  October 2, 2009 at 9:21 am

  #1061008

  Hi, I have written some SQL in the past that might just give you what you are looking for this will outout to a file in C:\temp called Security_Report.txt.

  File is attahced. Rename to .sql before running it.

  MCITP SQL 2005, MCSA SQL 2012