Table of Contents

Class CompatibilitySchema.User

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

sys.sysusers (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Contains one row for each Microsoft Windows user, Windows group, Microsoft SQL Server user, or SQL Server role in the database.

important


This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). 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.


See sys.sysusers.

[Table(Schema = "sys", Name = "sysusers", IsView = true)]
public class CompatibilitySchema.User
Inheritance
CompatibilitySchema.User
Extension Methods

Properties

Altuid

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Overflows or returns NULL if the number of users and roles exceeds 32,767.

[Column("altuid")]
[Nullable]
public short? Altuid { get; set; }

Property Value

short?

Createdate

Date the account was added.

[Column("createdate")]
[NotNull]
public DateTime Createdate { get; set; }

Property Value

DateTime

Environ

Reserved.

[Column("environ")]
[Nullable]
public string? Environ { get; set; }

Property Value

string

Gid

Group ID to which this user belongs. If uid is the same as gid, this entry defines a group. Overflows or returns NULL if the combined number of groups and users exceeds 32,767.

[Column("gid")]
[Nullable]
public short? Gid { get; set; }

Property Value

short?

Hasdbaccess

1 = Account has database access.

[Column("hasdbaccess")]
[Nullable]
public int? Hasdbaccess { get; set; }

Property Value

int?

Isaliased

1 = Account is aliased to another user.

[Column("isaliased")]
[Nullable]
public int? Isaliased { get; set; }

Property Value

int?

Isapprole

1 = Account is an application role.

[Column("isapprole")]
[Nullable]
public int? Isapprole { get; set; }

Property Value

int?

Islogin

1 = Account is a Windows group, Windows user, or SQL Server user with a login account.

[Column("islogin")]
[Nullable]
public int? Islogin { get; set; }

Property Value

int?

Isntgroup

1 = Account is a Windows group.

[Column("isntgroup")]
[Nullable]
public int? Isntgroup { get; set; }

Property Value

int?

Isntname

1 = Account is a Windows group or Windows user.

[Column("isntname")]
[Nullable]
public int? Isntname { get; set; }

Property Value

int?

Isntuser

1 = Account is a Windows user.

[Column("isntuser")]
[Nullable]
public int? Isntuser { get; set; }

Property Value

int?

Issqlrole

1 = Account is a SQL Server role.

[Column("issqlrole")]
[Nullable]
public int? Issqlrole { get; set; }

Property Value

int?

Issqluser

1 = Account is a SQL Server user.

[Column("issqluser")]
[Nullable]
public int? Issqluser { get; set; }

Property Value

int?

Name

User name or group name, unique in this database.

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

Property Value

string

Password

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[Column("password")]
[Nullable]
public byte[]? Password { get; set; }

Property Value

byte[]

Roles

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[Column("roles")]
[Nullable]
public byte[]? Roles { get; set; }

Property Value

byte[]

SID

Security identifier for this entry.

[Column("sid")]
[Nullable]
public byte[]? SID { get; set; }

Property Value

byte[]

Status

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

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

Property Value

short?

UID

User ID, unique in this database.

1 = Database owner

Overflows or returns NULL if the number of users and roles exceeds 32,767.

[Column("uid")]
[Nullable]
public short? UID { get; set; }

Property Value

short?

Updatedate

Date the account was last changed.

[Column("updatedate")]
[NotNull]
public DateTime Updatedate { get; set; }

Property Value

DateTime