Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Auditing/Reporting Software 1

Status
Not open for further replies.

alepore

MIS
Jun 25, 2001
27
US
I am a self admitted SQL dummy. I need to run audits on SQL permissions and database info and was wondering if anyone can recommend a lesser expensive reporting software I can use? I hope that is enough information. Thanks in advance for your help.
 
You may not really need a bit of software to do this, as this information is all stored by SQL, so it might be worth having a look at the SYSUSERS table.

Try having a look in the BOL, or maybe try just looking at the contents of that table and see if it helps.

If you know specifically what information you need to show in the report its probably worth posting that; someone here may already have written a query to do that which they may be prepared to post up for you to use.



Fee.

"The question should be, is it worth trying to do, not can it be done"


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top