This topic has not yet been rated - Rate this topic

ServerRole.EnumServerRolePermissions Method

SQL Server 2012

Note: This API is now obsolete.

Returns a list of server permissions assigned to the referenced server role.

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

Syntax

C++

JScript

[ObsoleteAttribute]
public DataTable EnumServerRolePermissions()

Return Value

Type: System.Data.DataTable
An array of DataTable object values that contain information about server permissions assigned to the server role. The table describes the different columns of the returned DataTable.

Column	Data type	Description
ServerRole	String	The fixed server role, for example, sysadmin.
Permission	String	The description of the server role permission.

Examples

Managing Users, Roles, and Logins

Reference

ServerRole Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Permissions of Fixed Server Roles (Database Engine)

sp_addsrvrolemember (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD