Class SecuritySchema.DatabaseCredential

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.database_credentials (Transact-SQL)

Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics

Returns one row for each database scoped credential in the database.

important

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use sys.database_scoped_credentials instead.

See sys.database_credentials.

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

Inheritance

object

SecuritySchema.DatabaseCredential

Extension Methods

Map.DeepCopy<T>(T)

Properties

CreateDate

Time at which the database scoped credential was created.

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

Property Value

DateTime

CredentialID

ID of the database scoped credential. Is unique in the database.

[Column("credential_id")]
[NotNull]
public int CredentialID { get; set; }

Property Value

int

CredentialIdentity

Name of the identity to use. This will generally be a Windows user. It does not have to be unique.

[Column("credential_identity")]
[Nullable]
public string? CredentialIdentity { get; set; }

Property Value

string

ModifyDate

Time at which the database scoped credential was last modified.

[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

Name of the database scoped credential. Is unique in the database.

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

Property Value

string

TargetID

ID of the object that the database scoped credential is mapped to. Returns 0 for database scoped credentials

[Column("target_id")]
[Nullable]
public int? TargetID { get; set; }

Property Value

int?

TargetType

Type of database scoped credential. Returns NULL for database scoped credentials.

[Column("target_type")]
[Nullable]
public string? TargetType { get; set; }

Property Value

string