United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Database Engine)

SQL Server Management Objects

SQL Server Management Objects Reference

Microsoft.SqlServer.Management.Smo

Login Class

Login Methods

AddCredential Method

AddToRole Method

Alter Method

ChangePassword Method

Create Method

Deny Method

Disable Method

Drop Method

DropCredential Method

Enable Method

EnumAgentProxyAccounts Method

EnumCredentials Method

EnumDatabaseMappings Method

EnumObjectPermissions Method

GetDatabaseUser Method

Grant Method

Initialize Method

IsMember Method

ListMembers Method

Refresh Method

Rename Method

Revoke Method

Script Method

This topic has not yet been rated - Rate this topic

Login.AddToRole Method

SQL Server 2012

Other Versions

Adds the login account to a SQL Server role.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public void AddToRole(
	string role
)

Parameters

role: Type: System.String
A String value that specifies the name of the role.

Examples

Managing Users, Roles, and Logins

Reference

Login Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Principals (Database Engine)

CREATE LOGIN (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Manage Your Profile

|

Site Feedback