Enable SQL Audit Log.sql

USE [master]
GO

/****** Object:  Audit [LetsBank_Audit]    Script Date: 9/3/2022 3:34:34 PM ******/
CREATE SERVER AUDIT [LetsBank_Audit]
TO FILE 
(	FILEPATH = N'F:\SQL Audit\'
	,MAXSIZE = 1024 MB
	,MAX_ROLLOVER_FILES = 10
	,RESERVE_DISK_SPACE = ON
) WITH (QUEUE_DELAY = 1000, ON_FAILURE = CONTINUE, AUDIT_GUID = '9fefb1ee-be41-4b82-867c-0fa7f9ee99c6')
ALTER SERVER AUDIT [LetsBank_Audit] WITH (STATE = ON)
GO


USE [master]
GO

CREATE SERVER AUDIT SPECIFICATION [LetsBank_Audit_Specification]
FOR SERVER AUDIT [LetsBank_Audit]
ADD (SCHEMA_OBJECT_ACCESS_GROUP),
ADD (DATABASE_ROLE_MEMBER_CHANGE_GROUP),
ADD (SERVER_ROLE_MEMBER_CHANGE_GROUP),
ADD (BATCH_COMPLETED_GROUP),
ADD (BATCH_STARTED_GROUP),
ADD (AUDIT_CHANGE_GROUP),
ADD (FAILED_DATABASE_AUTHENTICATION_GROUP),
ADD (DATABASE_PERMISSION_CHANGE_GROUP),
ADD (DATABASE_OBJECT_PERMISSION_CHANGE_GROUP),
ADD (SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP),
ADD (SERVER_PRINCIPAL_IMPERSONATION_GROUP),
ADD (FAILED_LOGIN_GROUP),
ADD (DATABASE_OBJECT_CHANGE_GROUP),
ADD (SCHEMA_OBJECT_CHANGE_GROUP),
ADD (SERVER_PRINCIPAL_CHANGE_GROUP),
ADD (SERVER_OPERATION_GROUP),
ADD (APPLICATION_ROLE_CHANGE_PASSWORD_GROUP),
ADD (LOGIN_CHANGE_PASSWORD_GROUP),
ADD (SENSITIVITY_CLASSIFICATION_CHANGE_GROUP),
ADD (DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP),
ADD (TRANSACTION_COMMIT_GROUP),
ADD (TRANSACTION_BEGIN_GROUP),
ADD (TRANSACTION_ROLLBACK_GROUP),
ADD (USER_CHANGE_PASSWORD_GROUP)
WITH (STATE = ON)
GO