Server.Grant Method

Grants the specified set of permissions to the specified grantees on the instance of Microsoft SQL Server.

备注

已更新的文本：

The Grant method has several overloads that give you a choice of whether to grant one or more permission to a single grantee or to several grantees. It also lets you specify whether the grantee has permission to give other users permission, and what role the grantee assumes when taking this action.

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

重载列表

名称	Description
Server.Grant (ServerPermissionSet, String)	Grants the specified set of permissions to the specified grantee on the instance of Microsoft SQL Server.
Server.Grant (ServerPermissionSet, String[])	Grants the specified set of permissions to the specified grantees on the instance of Microsoft SQL Server.
Server.Grant (ServerPermissionSet, String, Boolean)	Grants access to the specified permission to the grantee and the ability to grant access to other users on the instance of Microsoft SQL Server.
Server.Grant (ServerPermissionSet, String[], Boolean)	Grants access to the specified permission to the grantees and the ability to grant access to other users on the instance of Microsoft SQL Server.
Server.Grant (ServerPermissionSet, String, Boolean, String)	Grants the specified set of permissions to the grantee and the ability to grant the set of permissions to other users on the instance of Microsoft SQL Server under an assumed role.
Server.Grant (ServerPermissionSet, String[], Boolean, String)	Grants the specified set of permissions to the grantees and the ability to grant the set of permissions to other users on the instance of Microsoft SQL Server under an assumed role.

请参阅

参考

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

其他资源

How to: Grant Server Permissions in Visual Basic .NET
Granting, Revoking, and Denying Permissions
管理服务器