audit_event_name
Description
Returns
a description of an audit event.
Syntax
audit_event_name(event_id)
Parameters
- event_id
is the number of an audit event.
Examples
Example 1
Queries the audit trail for table creation events:
select * from audit_data where audit_event_name(event) = "Create Table"
Example 2
Obtains current audit event values. See the Usage
section below for a complete list of audit values and their descriptions.
create table #tmp(event_id int, description varchar(255))
go
declare @a int
select @a=1
while (@a<120)
begin
insert #tmp values (@a, audit_event_name(@a))
select @a=@a + 1
end
select * from #tmp
go
-----------------------------------------
event_id description
--------- -------------------
1 Ad hoc Audit Record
2 Alter Database
...
104 Create Index
105 Drop Index
Usage
The following lists the ID and name of each of the audit events:
1 Ad Hoc Audit record
2 Alter Database
3 Alter table
4 BCP In
5 NULL
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 Nonfatal Error
|
|
74
Auditing Disabled
75 NULL
76 SSO Changed Password
79 NULL
80 Role Check Performed
81 DBCC Command
82 Config
83 Online Database
84 Setuser Command
85 User-defined Function Command
86 Built-in Function
87 Disk Release
88 Set SSA 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
106 NULL
107 NULL
108 NULL
109 NULL
110 Deploy UDWS
111 Undeploy UDWS
115 Password Administration
|
Adaptive Server does not log events if audit_event_name returns
NULL.
Standards
ANSI SQL – compliance level: Transact-SQL extension.
Permissions
Any user can execute audit_event_name.
See also
Commands select, sp_audit