ServerRole.EnumServerRolePermissions Method

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

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Function EnumServerRolePermissions As DataTable
public DataTable EnumServerRolePermissions ()
public:
DataTable^ EnumServerRolePermissions ()
public DataTable EnumServerRolePermissions ()
public function EnumServerRolePermissions () : 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.

备注

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

How to: Use a Simple SMO Method in Visual Basic .NET

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

ServerRole Class
ServerRole Members
Microsoft.SqlServer.Management.Smo Namespace

其他资源

Managing Users, Roles, and Logins
固定服务器角色的权限
sp_addsrvrolemember (Transact-SQL)