Security Info script

• EasyBoy

  SSCertifiable

  Points: 5301

  More actions

  August 10, 2010 at 2:03 am

  #387538

  Hello ALL,

  How can i get all security information by server / by database and put it in a reportable format?

  Thanks a lot for your help in advance.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  August 10, 2010 at 9:07 am

  #1204856

  You may use sp_helplogins to get the login details and the mappings.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga