ServerRole.EnumServerRolePermissions Method

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

'Bildirim
<ObsoleteAttribute> _
Public Function EnumServerRolePermissions As DataTable
'Kullanım
Dim instance As ServerRole
Dim returnValue As DataTable

returnValue = instance.EnumServerRolePermissions()

[ObsoleteAttribute]
public DataTable EnumServerRolePermissions()

[ObsoleteAttribute]
public:
DataTable^ EnumServerRolePermissions()

[<ObsoleteAttribute>]
member EnumServerRolePermissions : unit -> DataTable 

public function EnumServerRolePermissions() : DataTable

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

See Also

Reference

ServerRole Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Permissions of Fixed Server Roles (Database Engine)

sp_addsrvrolemember (Transact-SQL)