Class CompatibilitySchema.OleDBUser

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.sysoledbusers (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

important

This SQL Server 2000 (8.x) system table is included in SQL Server as a view for backward compatibility only. We recommend that you use catalog views instead.

Contains one row for each user and password mapping for the specified linked server. sysoledbusers is stored in the master database.

See sys.sysoledbusers.

[Table(Schema = "sys", Name = "sysoledbusers", IsView = true)]
public class CompatibilitySchema.OleDBUser

Inheritance

object

CompatibilitySchema.OleDBUser

Extension Methods

Map.DeepCopy<T>(T)

Properties

Changedate

Date the mapping information was last changed.

[Column("changedate")]
[NotNull]
public DateTime Changedate { get; set; }

Property Value

DateTime

Loginsid

SID of the local login to be mapped.

[Column("loginsid")]
[Nullable]
public byte[]? Loginsid { get; set; }

Property Value

byte[]

Rmtloginame

Name of the remote login that loginsid maps to for linked rmtservid.

[Column("rmtloginame")]
[Nullable]
public string? Rmtloginame { get; set; }

Property Value

string

Rmtpassword

Returns NULL.

[Column("rmtpassword")]
[Nullable]
public string? Rmtpassword { get; set; }

Property Value

string

Rmtsrvid

Security identification number (SID) of the server.

[Column("rmtsrvid")]
[Nullable]
public short? Rmtsrvid { get; set; }

Property Value

short?

Status

If 1, the mapping should use the credentials of the user.

[Column("status")]
[Nullable]
public short? Status { get; set; }

Property Value

short?