What editions have the SQL Server audit feature?

What editions have the SQL Server audit feature?

Supported Audit Database SQL Server Versions

Which edition of SQL Server have the granular audit capability?

SQL Server 2012 made server-level auditing partially available to all editions, leaving only the more granular database-level auditing still exclusive to the Enterprise edition. Staring SQL Server 2016 SP1, all auditing features, that is both server-level and database-level auditing are available to all editions.

What versions of SQL Server are there?

Versions

Is the server level auditing available in SQL Server 2012?

SQL Server 2012 made server-level auditing partially available to all editions, leaving only the more granular database-level auditing still exclusive to the Enterprise edition. Staring SQL Server 2016 SP1, all auditing features, that is both server-level and database-level auditing are available to all editions.

Where are audited events written in SQL Server?

Audited events can be written to the Windows event logs or to binary audit files which can later be analyzed using T-SQL. Audits consist of a server level audit which defines where the audit log records will be written. Database and server level audits can be filtered on particular users.

What are the components of a SQL Server audit?

SQL Server Audit Components. An audit is the combination of several elements into a single package for a specific group of server actions or database actions. The components of SQL Server audit combine to produce an output that is called an audit, just as a report definition combined with graphics and data elements produces a report.

What are the permission requirements for SQL audit?

Each feature and command for SQL Server Audit has individual permission requirements. To create, alter, or drop a Server Audit or Server Audit Specification, server principals require the ALTER ANY SERVER AUDIT or the CONTROL SERVER permission.