Share via


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

'Declaration
<ObsoleteAttribute> _
Public Function EnumServerRolePermissions As DataTable
'Usage
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)