Scanning the server logins to ascertain database permissions

• Jim Ruddy-351405

  SSC Journeyman

  Points: 78

  More actions

  July 21, 2006 at 11:32 am

  #92138

  To all scripting gurus!!

  I have to maintain interior security for over 1500 SQL Server (2000), and need a scanning script that will run through the list of all logins in the security folder in Enterprise Manager for each server and pull out and display (not the server roles but) the default database and all database permissions for each login. Any suggestions?

   

  Thanks in advance

  Jim Ruddy

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  July 21, 2006 at 12:55 pm

  #650835

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1158

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1159

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=515

  Last one may be what you are looking for with some minor modifications!

  Wes