Class SecuritySchema.ServerAuditSpecificationDetail

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.server_audit_specification_details (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains information about the server audit specification details (actions) in a SQL Server audit on a server instance. 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.server_audit_specification_details.

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

Inheritance

object

SecuritySchema.ServerAuditSpecificationDetail

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 group or name of audit action

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

Property Value

string

AuditedPrincipalID

Reserved

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

Property Value

int

AuditedResult

Audited result:

- SUCCESS AND FAILURE

- SUCCESS

- FAILURE

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

Property Value

string

Class

Reserved

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

Property Value

byte

ClassDesc

Reserved

[Column("class_desc")]
[Nullable]
public string? ClassDesc { get; set; }

Property Value

string

IsGroup

Whether the audited object is a group:

0 - Not a group

1 - Group

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

Property Value

bool?

MajorID

Reserved

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

Property Value

int

MinorID

Reserved

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

Property Value

int

ServerSpecificationID

ID of the audit server specification

[Column("server_specification_id")]
[NotNull]
public int ServerSpecificationID { get; set; }

Property Value

int