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. |