Category: ASE: Auditing

Audit Events

Audit Events are occurences logged during auditing. Audit events can be determined using the system function audit_event_name().

There are nearly 100 audit events. They can be displayed using the following stored procedure:

    create procedure sp_audit_events as

    

    create table #auditevents(audit_event_id int, audit_event varchar(50) NULL)

    

    declare @a int, @b varchar(50)

    select @a=1

    

    while (@a<130)

    begin

      insert #auditevents values(@a, audit_event_name(@a))  

      select @a=@a + 1

    end

    select * from #auditevents where audit_event <> NULL

This is a list of all audit events and their respective audit_event_id

1	Ad hoc Audit Record
2	Alter Database
3	Alter Table
4	BCP In
6	Bind Default
7	Bind Message
8	Bind Rule
9	Create Database
10	Create Table
11	Create Procedure
12	Create Trigger
13	Create Rule
14	Create Default
15	Create Message
16	Create View
17	Access to Database
18	Delete Table
19	Delete View
20	Disk Init
21	Disk Refit
22	Disk Reinit
23	Disk Mirror
24	Disk Unmirror
25	Disk Remirror
26	Drop Database
27	Drop Table
28	Drop Procedure
29	Drop Trigger
30	Drop Rule
31	Drop Default
32	Drop Message
33	Drop View
34	Dump Database
35	Dump Transaction
36	Fatal Error
37	Non Fatal Error
38	Execution of Stored Procedure
39	Execution of Trigger
40	Grant Command
41	Insert Table
42	Insert View
43	Load Database
44	Load Transaction
45	Login
46	Logout
47	Revoke Command
48	RPC In
49	RPC Out
50	Server Boot
51	Server Shutdown
52	Curread Modification
53	Curwrite Modification
54	Update Mode Modification
55	Role Toggling
58	Truncation of Audit Table
61	Access to Audit Table
62	Select Table
63	Select View
64	Truncate Table
65	Trusted Procedure execution
66	Trusted Trigger execution
67	Unbind Default
68	Unbind Rule
69	Unbind Message
70	Update Table
71	Update View
73	Auditing Enabled
74	Auditing Disabled
76	SSO Changed Password
77	Table Change
78	Audit Option Change
80	Role Check Performed
81	DBCC Command
82	Config
83	Online Database
84	Setuser Command
85	UDR Command
86	Built-in Function
87	Disk Release
88	Set SSA Command
89	Kill/Terminate Command
90	Connect Command
91	Reference
92	Command Text
93	JCS Install Command
94	JCS Remove Command
95	Unlock Admin Account
96	Quiesce Database Command
97	Create SQLJ Function
98	Drop SQLJ Function
99	SSL Administration
100	Disk Resize
101	Mount Database
102	Unmount Database
103	Login Command
104	Create Index
105	Drop Index

See also:
Auditing,
sp_audit and
audit_event_name.