Fast1data.SqlServer/example/audit/audit-00.sql at main · corelevel/Fast1data.SqlServer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
create server audit [fast1_audit_00]
to file (filepath = 'C:\Temp\', maxsize = 1024 MB, max_rollover_files = 4, reserve_disk_space = off)
with (queue_delay = 1000, on_failure = continue)
go
alter server audit [fast1_audit_00] with (state = on)
go

create server audit specification [fast1_audit_spec_00]
for server audit [fast1_audit_00]
add (audit_change_group),
add (database_change_group),

add (database_object_change_group),
add (database_object_ownership_change_group),
add (database_object_permission_change_group),

add (database_ownership_change_group),
add (database_permission_change_group),
add (database_principal_change_group),
add (database_role_member_change_group),

add (schema_object_change_group),
add (schema_object_ownership_change_group),
add (schema_object_permission_change_group),

add (server_object_change_group),
add (server_object_ownership_change_group),
add (server_object_permission_change_group),

add (server_permission_change_group),
add (server_principal_change_group),

add (server_role_member_change_group),

add (dbcc_group)
with (state = on)
go