Class SecuritySchema.DatabaseAuditSpecificationDetail

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.database_audit_specification_details (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains information about the database audit specifications in a SQL Server audit on a server instance for all databases. For more information, see SQL Server Audit (Database Engine). For a list of all audit_action_id's and their names, query sys.dm_audit_actions (Transact-SQL).

See sys.database_audit_specification_details.

[Table(Schema = "sys", Name = "database_audit_specification_details", IsView = true)]
public class SecuritySchema.DatabaseAuditSpecificationDetail

Inheritance

object

SecuritySchema.DatabaseAuditSpecificationDetail

Extension Methods

Map.DeepCopy<T>(T)

Properties

AuditActionID

ID of the audit action.

[Column("audit_action_id")]
[NotNull]
public int AuditActionID { get; set; }

Property Value

int

AuditActionName

Name of audit action or audit action group

[Column("audit_action_name")]
[Nullable]
public object? AuditActionName { get; set; }

Property Value

object

AuditedPrincipalID

Principal that is being audited.

[Column("audited_principal_id")]
[NotNull]
public int AuditedPrincipalID { get; set; }

Property Value

int

AuditedResult

Audit action results:

- SUCCESS AND FAILURE - SUCCESS

- FAILURE

[Column("audited_result")]
[Nullable]
public object? AuditedResult { get; set; }

Property Value

object

Class

Identifies class of object which is being audited.

[Column("class")]
[NotNull]
public int Class { get; set; }

Property Value

int

ClassDesc

Description of class of object which is being audited:

- SCHEMA

- TABLE

[Column("class_ desc")]
[NotNull]
public object ClassDesc { get; set; }

Property Value

object

DatabaseSpecificationID

ID of the audit specification.

[Column("database_specification_id")]
[NotNull]
public int DatabaseSpecificationID { get; set; }

Property Value

int

IsGroup

Shows whether the object is a group:

0 - Not a group

1 - Group

[Column("is_group")]
[Nullable]
public object? IsGroup { get; set; }

Property Value

object

MajorID

Major ID of object being audited, such as a Table ID of a Table Audit action.

[Column("major_id")]
[NotNull]
public int MajorID { get; set; }

Property Value

int

MinorID

Secondary ID of object that is being audited, interpreted according to class, such as the column ID of a Table Audit action.

[Column("minor_id")]
[NotNull]
public object MinorID { get; set; }

Property Value

object