Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |