Date: Fri, 29 Mar 2024 11:10:35 +0000 (UTC) Message-ID: <900160147.69933.1711710635631@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69932_1498782709.1711710635628" ------=_Part_69932_1498782709.1711710635628 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
You can specify which SQL events you want to audit at the server= level. IDERA SQL Compliance Manager applies these settings to th= e registered SQL Server instance. These settings are not applied to the hos= ted databases.
You can configure server audit settings when you register a new SQL Serv= er instance or later as your auditing needs change. For more information ab= out individual SQL events, see Microsoft SQL Server Books Online.
Event class | SQL Server version | Description |
---|---|---|
Audit Add Login | SQL Server 2000 only | Records when a SQL Server login is added to or d=
ropped from a registered SQL Server instance In SQL Server 2005 and later, this event class is Audit Server Principal M= anagement |
Audit Add Login To Server Role | SQL Server 2000 and later | Records when a login is added to or removed from= a server role |
Audit Change Database Owner | SQL Server 2005 and later | Records when the ALTER AUTHORIZATION statement i= s used to specify a different database owner |
Audit Database Management | SQL Server 2005 | Records all DROP, ALTER, and CREATE operations o= n a database |
Audit Login | SQL Server 2000 and later | Records all successful logins on the registered = SQL Server instance |
Audit Login Change Password | SQL Server 2000 and later | Records all password changes for logins on the r= egistered SQL Server instance |
Audit Login Change Properties | SQL Server 2000 and later | Records changes in default database and language= properties for all logins on the registered SQL Server instance |
Audit Login Failed | SQL Server 2000 and later | Records all logins that failed an access check o= n the registered SQL Server instance |
Audit Login GDR | SQL Server 2000 only | Records all GRANT, REVOKE, or DENY actions on Wi=
ndows 2000 user account login rights In SQL Server 2005 and later, this event class is Audit Server Principal M= anagement |
Audit Object Derived Permission | SQL Server 2000 only | Records CREATE and DROP commands executed on a s=
erver object, such as CREATE DATABASE or DROP DATABASE In SQL Server 2005 and later, this event class is Audit Database Managemen= t |
Audit Server Alter Trace | SQL Server 2005 and later | Records when an ALTER TRACE permission check is = executed for a T-SQL statement that creates, configures, or filters a SQL t= race |
Audit Server Object GDR | SQL Server 2005 and later | Records all GRANT, REVOKE, or DENY actions on pe= rmissions for executing T-SQL statements on the audited schema object, such= as a table or function |
Audit Server Object Management | SQL Server 2005 and later | Records all DROP, ALTER, and CREATE operations o= n server objects |
Audit Server Object Take Ownership | SQL Server 2005 and later | Records when ownership of an audited server obje= ct changes |
Audit Server Operation | SQL Server 2005 and later | Records all security operations executed on the = audited server |
Audit Server Principal Impersonation | SQL Server 2005 and later | Records when impersonation is used to access or = act on a server object |
Audit Server Principal Management | SQL Server 2005 and later | Records all DROP, ALTER, and CREATE operations o= n server principals |
Audit Server Scope GDR | SQL Server 2005 and later | Records all GRANT, REVOKE, or DENY actions on pe= rmissions for executing T-SQL statements that change the server scope, such= as creating a login |
Audit Statement Permission | SQL Server 2000 only | Records when a user is authorized to execute a T=
-SQL statement on the registered SQL Server instance In SQL Server 2005 and later, this event class is Audit Database Managemen= t |
SQL Compliance Ma=
nager audits all acti=
vity on your server. Learn more >=
; >
IDERA Website | Product= s | Buy | Support&= nbsp;| Community | About Us&n= bsp;| Resources | Legal