Table of Contents

Class SqlDatabaseUser

Namespace
CENTREL.XIA.Configuration.Types
Assembly
CENTREL.XIA.Configuration.Types.dll

Represents a SQL server database user.

public class SqlDatabaseUser : BaseTypeSection, IComparable<SqlDatabaseUser>
Inheritance
SqlDatabaseUser
Implements

Constructors

SqlDatabaseUser()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlDatabaseUser class.

public SqlDatabaseUser()

Properties

AsymmetricKey

Gets or sets the asymmetric key for the user. This only applies when the asymmetric key is assigned directly to the user, rather than an associated login.

public string AsymmetricKey { get; set; }

Property Value

string

AuthenticationType

Gets or sets the authentication type of the user.

public SqlDatabaseUserAuthenticationType AuthenticationType { get; set; }

Property Value

SqlDatabaseUserAuthenticationType

AuthenticationTypeString

Gets the authentication type of the user as a human readable string.

public string AuthenticationTypeString { get; set; }

Property Value

string

Certificate

Gets or sets the certificate for the user. This only applies when the certificate is assigned directly to the user, rather than an associated login.

public string Certificate { get; set; }

Property Value

string

CreationDate

Gets or sets the date and time that the user was created.

public DateTime CreationDate { get; set; }

Property Value

DateTime

DatabaseRoles

Gets or sets the database roles to which the user is a member.

public SerializableStringCollection DatabaseRoles { get; set; }

Property Value

SerializableStringCollection

DateLastModified

Gets or sets the date and time the user was last modified.

public DateTime DateLastModified { get; set; }

Property Value

DateTime

DefaultLanguage

Gets or sets the default language for the user. This only applies to on-premises installations of SQL Server.

public string DefaultLanguage { get; set; }

Property Value

string

DefaultSchema

Gets or sets the default schema for the user.

public string DefaultSchema { get; set; }

Property Value

string

ExtendedProperties

Gets or sets the extended properties for the database user.

public SqlExtendedProperties ExtendedProperties { get; set; }

Property Value

SqlExtendedProperties

Identifier

Gets or sets the unique identifier of the database user. This is for internal system use only.

public Guid Identifier { get; set; }

Property Value

Guid

IsWindowsLogin

Gets or sets whether the login to which the user is mapped is a Windows user or group login.

[Browsable(false)]
public bool IsWindowsLogin { get; }

Property Value

bool

Login

Gets or sets the login associated with the user.

public string Login { get; set; }

Property Value

string

LoginType

Gets or sets the login type for the user.

public SqlLoginType LoginType { get; set; }

Property Value

SqlLoginType

Name

Gets or sets the name of the user.

public string Name { get; set; }

Property Value

string

OwnedSchemas

Gets or sets the schemas owned by the user.

public SerializableStringCollection OwnedSchemas { get; set; }

Property Value

SerializableStringCollection

Sid

Gets or sets the security identifier of the user in SDDL format for Windows users and group based logins, otherwise a SQL Server SID encoded as a string.

public string Sid { get; set; }

Property Value

string

UserType

Gets or sets the user type.

public SqlDatabaseUserType UserType { get; set; }

Property Value

SqlDatabaseUserType

UserTypeString

Gets the user type as a human readable string.

public string UserTypeString { get; set; }

Property Value

string

Methods

Clone()

Returns a CENTREL.XIA.Configuration.Types.SqlDatabaseUser cloned from this object.

public SqlDatabaseUser Clone()

Returns

SqlDatabaseUser

A CENTREL.XIA.Configuration.Types.SqlDatabaseUser.

CompareTo(SqlDatabaseUser)

Compares two CENTREL.XIA.Configuration.Types.SqlDatabaseUser objects to allow sorting alphabetically by name.

public int CompareTo(SqlDatabaseUser other)

Parameters

other SqlDatabaseUser

The CENTREL.XIA.Configuration.Types.SqlDatabaseUser to compare to.

Returns

int

The sort order of the two CENTREL.XIA.Configuration.Types.SqlDatabaseUser objects.