Class SecuritySchema.Credential

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.credentials (Transact-SQL)

APPLIES TO: (Yes) SQL Server (Yes) Azure SQL Managed Instance Azure Synapse Analytics (Yes) Parallel Data Warehouse

Returns one row for each server-level credential.

See sys.credentials.

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

Inheritance

object

SecuritySchema.Credential

Extension Methods

Map.DeepCopy<T>(T)

Properties

CreateDate

Time at which the credential was created.

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

Property Value

DateTime

CredentialID

ID of the credential. Is unique in the server.

[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 credential was last modified.

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

Property Value

DateTime

Name

Name of the credential. Is unique in the server.

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

Property Value

string

TargetID

ID of the object that the credential is mapped to. Returns 0 for traditional credentials and non-0 for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM).

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

Property Value

int?

TargetType

Type of credential. Returns NULL for traditional credentials, CRYPTOGRAPHIC PROVIDER for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM).

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

Property Value

string