Share via


SqlAuditActionGroup Enumeration

SQL Server audit action groups.

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)

Syntax

'Declaration
Public Enumeration SqlAuditActionGroup
public enum SqlAuditActionGroup
public enum class SqlAuditActionGroup
type SqlAuditActionGroup
public enum SqlAuditActionGroup

Members

Member name Description
None Specifies that no action group was provided.
SuccessfulLogin Indicates that a principal has successfully logged in to SQL Server.
Logout Indicates that a principal has logged out of SQL Server.
ServerStateChange This event is raised when the SQL Server service state is modified.
FailedLogin Indicates that a principal tried to log on to SQL Server and failed.
LoginChangePassword This event is raised whenever a login password is changed by way of an ALTER LOGIN statement or sp_password stored procedure.
ServerRoleMemberChange This event is raised whenever a login is added or removed from a fixed server role.
ServerPrincipalImpersonation This event is raised when an impersonation occurs in server scope, such as EXECUTE AS <login>.
ServerObjectOwnershipChange This event is raised when the permission to change the owner of a schema object (such as a table, procedure, or function) is checked.
DatabaseMirroringLogin This event is raised to report audit messages related to database mirroring transport security.
BrokerLogin This event is raised to report audit messages related to Service Broker transport security.
ServerPermissionChange This event is raised when a GRANT, REVOKE, or DENY is issued for permissions in the server scope, such as creating a login.
ServerObjectPermissionChange This event is raised whenever a grant, deny, or revoke is performed against a schema object.
ServerOperation This event is raised when Security Audit operations (such as altering settings, resources, external access, or authorization) are used.
TraceChange This event is raised for all statements that check for the ALTER TRACE permission.
ServerObjectChange This event is raised for CREATE, ALTER, or DROP operations on server objects.
ServerPrincipalChange This event is raised when server principals are created, changed, or dropped.
DatabasePermissionChange This event is raised whenever a GRANT, REVOKE, or DENY is issued for a statement permission by any principal in SQL Server.

This applies to database-only events, such as granting permissions on a database.

SchemaObjectPermissionChange This event is raised whenever a grant, deny, revoke is performed against a schema object.
DatabaseRoleMemberChange This event is raised whenever a login is added to or removed from a database role.

This event class is raised for the sp_addrolemember, sp_changegroup, and sp_droprolemember stored procedures.

ApplicationRoleChangePassword This event is raised whenever a password is changed for an application role.
SchemaObjectAccess This event is raised whenever an object permission has been used in the schema.
BackupRestore This event is raised whenever a backup or restore command is issued.
Dbcc This event is raised whenever a principal issues any DBCC command.
AuditChange This event is raised whenever any audit specification is created, modified, or deleted.
DatabaseChange This event is raised when a database is created, altered, or dropped.
DatabaseObjectChange This event is raised when a CREATE, ALTER, or DROP statement is executed on database objects, such as schemas.
DatabasePrincipalChange This event is raised when principals, such as users, are created, altered, or dropped from a database.
SchemaObjectChange This event is raised when a CREATE, ALTER, or DROP operation is performed on a schema.
DatabasePrincipalImpersonation This event is raised when an impersonation operation (such as EXECUTE AS <principal> or SETPRINCIPAL) occurs in the database scope.
DatabaseObjectOwnershipChange This event is raised when a change of owner occurs for objects in database scope.
DatabaseOwnershipChange This event is raised when you use the ALTER AUTHORIZATION statement to change the owner of a database, and the permissions that are required to do that are checked.
SchemaObjectOwnershipChange This event is raised when the permissions to change the owner of a schema object (such as a table, procedure, or function) is checked.
DatabaseObjectPermissionChange This event is raised when a GRANT, REVOKE, or DENY has been issued for database objects, such as assemblies and schemas.
DatabaseOperation This event is raised when operations in a database (such as checkpoint or subscribe query notification) occur.
DatabaseObjectAccess This event is raised whenever database objects such as message type, assembly, or contract are accessed.

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace