Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 Script to Audit my SQL Servers Security

Author  Topic 

Starting Member

2 Posts

Posted - 2002-03-28 : 15:43:08
ask2much writes "I am trying to write a script that will audit my sql servers looking for weaknesses etc. I need it to report things like users with NULL paswords, users with excessive acces rights, users with direct access to tables, etc. I need a query that will give me a list of all the users in the server, the last time they logged in, and the last time they changed their password. How can I accomplish this? also if any one has already created a script similar to the one I am trying to create, could I please take a look at it to get some ideas?

thank you,


Most Valuable Yak

15732 Posts

Posted - 2002-03-28 : 16:30:00
Take a look here:

You probably have to register to view it though. It's free.

Go to Top of Page

- Advertisement -