Table of Contents

Class SecuritySchema.DatabaseAuditSpecification

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.database_audit_specifications (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 more information, see SQL Server Audit (Database Engine).


See sys.database_audit_specifications.

[Table(Schema = "sys", Name = "database_audit_specifications", IsView = true)]
public class SecuritySchema.DatabaseAuditSpecification
Inheritance
SecuritySchema.DatabaseAuditSpecification
Extension Methods

Properties

AuditGuid

GUID for the audit that contains this specification. Used during enumeration of member database audit specifications during database attach/startup.

[Column("audit_guid")]
[Nullable]
public object? AuditGuid { get; set; }

Property Value

object

CreateDate

Date the audit specification was created.

[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

DatabaseSpecificationID

ID of the database specification.

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

Property Value

int

IsStateEnabled

Audit specification state:

0 - DISABLED

1 -ENABLED

[Column("is_state_enabled")]
[Nullable]
public bool? IsStateEnabled { get; set; }

Property Value

bool?

ModifiedDate

Date the audit specification was last modified.

[Column("modified_date")]
[NotNull]
public DateTime ModifiedDate { get; set; }

Property Value

DateTime

Name

Name of the auditing specification.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string