Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Auditing Options Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 9:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 10,193, Visits: 13,122
I've been asked to research auditing products for SQL Server, currently a mostly 2008 R2 environment. I'm wondering what people out there are using and what they've found are the strengths and weaknesses of what they are doing.

Here are some of the products I've found out there:



Right now we are just looking at auditing permissions, schema & configuration changes, and access. We aren't currently looking to audit changes to data.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1567560
Posted Monday, May 5, 2014 9:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 25, 2014 9:55 AM
Points: 1,288, Visits: 1,863
Jack Corbett (5/5/2014)
I've been asked to research auditing products for SQL Server, currently a mostly 2008 R2 environment. I'm wondering what people out there are using and what they've found are the strengths and weaknesses of what they are doing.

Here are some of the products I've found out there:



Right now we are just looking at auditing permissions, schema & configuration changes, and access. We aren't currently looking to audit changes to data.


If you only need auditing for permissions, schema & configuration changes, and access...all this is available within SQL Server 2008.
These links will help how to setup auditing:

http://technet.microsoft.com/en-us/library/dd392015%28v=sql.100%29.aspx
http://www.sqlservercentral.com/blogs/sqlrnnr/2010/03/19/security-audit/
http://www.sqlservercentral.com/blogs/cleveland-dba/2012/07/09/sql-audit-101-creating-a-basic-audit/
http://www.sqlservercentral.com/blogs/cleveland-dba/2012/07/16/sql-audit-102-reading-audit-output/
http://www.sqlservercentral.com/blogs/cleveland-dba/2012/07/31/sql-audit-201-creating-an-audit-solution/



Alex S
Post #1567567
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse