Class SecuritySchema.DatabaseRoleMember

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.database_role_members (Transact-SQL)

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

Returns one row for each member of each database role. Database users, application roles, and other database roles can be members of a database role. To add members to a role, use the ALTER ROLE statement with the ADD MEMBER option. Join with sys.database_principals to return the names of the principal_id values.

See sys.database_role_members.

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

Inheritance

object

SecuritySchema.DatabaseRoleMember

Extension Methods

Map.DeepCopy<T>(T)

Properties

MemberPrincipalID

Database principal ID of the member.

[Column("member_principal_id")]
[NotNull]
public int MemberPrincipalID { get; set; }

Property Value

int

RolePrincipalID

Database principal ID of the role.

[Column("role_principal_id")]
[NotNull]
public int RolePrincipalID { get; set; }

Property Value

int