security report

• malik

  SSC Rookie

  Points: 26

  More actions

  September 13, 2004 at 4:26 pm

  #83751

  Hello,

  I'm fairly new at administering sql servers and our security department just asked me to dump all object level permissions for all databases. I know how to manually do it but I somebody can share a script that'll be very helpful. I have 5 sql servers and about 20 dbs on each server.

   

  TIA

  Neil Malik

   

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  September 14, 2004 at 4:36 am

  #522911

  Check out this article

  http://www.sqlservercentral.com/columnists/cmiller/dumpsqlpermissions.asp

  M

  [font="Verdana"]Markus Bohse[/font]

• malik

  SSC Rookie

  Points: 26

  More actions

  September 14, 2004 at 1:12 pm

  #523054

  Thanks man - the tools is simply phenomenal.