SQL Server 2000/2005 Security Audit Scripts

Question

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

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

Donatello SSC Eights! Points: 853 More actions · Answer 1

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

dan.hare SSC Veteran Points: 286 More actions · Answer 2

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 More actions · Answer 3

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 More actions · Answer 4

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: 98 More actions · Answer 5

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 More actions · Answer 6

SSC Rookie

Points: 49

February 3, 2010 at 2:51 pm

Link is broken

webtekkie SSCommitted Points: 1901 More actions · Answer 7

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