SQL Server security: Auditing

Auditing requirements have had an impact on SQL Server security. Like with authentication and permissions, auditing requirements have become more stringent and encompassing, especially those in HIPAA, Sarbanes-Oxley and Basel II. Many companies now have a legal obligation to track not only who modified a particular piece of data but also who viewed it.

Since SQL Server 6 it has been possible to run Profiler to capture most queries and Data Manipulation Language (DML). SQL Server 2005 allows for richer auditing of events; for example, with Data Definition Language (DDL) triggers, you can audit schema changes and use Profiler to audit querying activity to see who views a particular table. However, using Profiler

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Relational Database Management Systems (RDBMSes) Troubleshooting a failed SQL Server 2008 installation Microsoft SQL Server 2008 guide Oracle Database 11g study guide Federated databases Metadata Basics Oracle RAC troubleshooting advice and application migration tips Oracle Database 11g tutorial Systems products to pay attention to Reasons to upgrade to SQL Server 2008 SQL Server security: Enhancements in encryption, authentication and auditing Database Management Services Troubleshooting a failed SQL Server 2008 installation Microsoft SQL Server 2008 guide Oracle Database 11g study guide FAQ: SQL Server 2008 high-availability services High-availability options in SQL Server 2008 Bridging the IT/business gap in business intelligence projects Business intelligence consulting: Problems and solutions Data management concerns of MDM-CDI architecture SSIS brings business intelligence services prospects Oracle RAC troubleshooting advice and application migration tips

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

for auditing consumes significant resources.

SQL Server 2008 introduces:

About the author

Hilary Cotter has been involved in IT for more than 20 years as a Web and database consultant. Microsoft first awarded Cotter the Microsoft SQL Server MVP award in 2001. Cotter received his bachelor of applied science degree in mechanical engineering from the University of Toronto and subsequently studied economics at the University of Calgary and computer science at UC Berkeley. He is the author of a book on SQL Server transactional replication and is currently working on books on merge replication and Microsoft search technologies.

Go to page: 1 - 2 - 3