SQL Server 2000/2005 Security Audit Scripts

  • StormNorm

    SSCommitted

    Points: 1653

    Comments posted to this topic are about the item SQL Server 2000/2005 Security Audit Scripts

  • Donatello

    SSC Eights!

    Points: 853

    Looks like a helpful article ... I just wish the scripts had uploaded.

  • dan.hare

    SSC Veteran

    Points: 286

    Working along with them at the moment, look like a very useful starting point.

    One point - I am going through and for each result set am putting in a blank first column to say what each resultset is.

    eg SELECT BlankOrEasyPasswords = '', Name...

    Thanks again for sharing.

    dan

  • dan.hare

    SSC Veteran

    Points: 286

    Some really good stuff in here, thanks again.

    One apparent omission is that the only permissions currently picked up are specific to a user, as opposed to a database or application role.

    It is useful to know which permissions have been assigned to a database role, and the users that are members of that role.

    I have written these in the past, will retrieve them if I can find them = )

    dan

  • nogoodboyo

    SSC-Addicted

    Points: 408

    What's going on here? The link is incomplete and the snippet that reamins links to some bible readings site.

  • chava.sreekanth

    SSC Journeyman

    Points: 97

    Are there still the scripts existing at the provided link.

    I am not access the URL provided.

    Can some help with the scripts.

    Thanks

    Sreekanth

  • asdfqwerty1

    SSC Rookie

    Points: 49

    Link is broken

  • webtekkie

    SSCommitted

    Points: 1901

    Yes, the link is broken. But I found it here...

    http://www.biblereadingschedule.com/nucleus/?catid=6&blogid=1

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply