How to determine the list of databases a login name has access to?

• Carmen Marculescu

  Newbie

  Points: 9

  More actions

  November 10, 2008 at 12:48 pm

  #196004

  How could we get a list of all the databases that a particular SQLServer login has access to?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 10, 2008 at 1:10 pm

  #896530

  Check out this article: http://www.builderau.com.au/program/sqlserver/soa/Reviewing-SQL-Server-Permissions/0,339028455,339293054,00.htm. I think it has the T-SQL you need.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question