USE [TestDB]
GO

CREATE DATABASE AUDIT SPECIFICATION [TestDB-DBSpec]
FOR SERVER AUDIT [TestDB-DBAudit]
ADD (DATABASE_ROLE_MEMBER_CHANGE_GROUP),
ADD (BATCH_COMPLETED_GROUP),
ADD (BACKUP_RESTORE_GROUP),
ADD (DELETE ON DATABASE::[TestDB] BY [public]),
ADD (EXECUTE ON DATABASE::[TestDB] BY [public]),
ADD (DATABASE_PERMISSION_CHANGE_GROUP),
ADD (SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP),
ADD (DATABASE_PRINCIPAL_IMPERSONATION_GROUP),
ADD (INSERT ON DATABASE::[TestDB] BY [public]),
ADD (DATABASE_OBJECT_CHANGE_GROUP),
ADD (DATABASE_PRINCIPAL_CHANGE_GROUP),
ADD (SCHEMA_OBJECT_CHANGE_GROUP),
ADD (SELECT ON DATABASE::[TestDB] BY [public]),
ADD (DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP),
ADD (UPDATE ON DATABASE::[TestDB] BY [public])
WITH (STATE = ON)
GO