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

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

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 Windows account in SDDL format. This only applies to Windows user or Windows group logins.

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.