共用方式為


Server.Grant 方法

包含保護的成員
包含繼承的成員

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

此成員已超載。如需此成員完整的詳細資訊 (包括語法、使用狀況及範例),按一下多載清單中的名稱。

多載 清單

  名稱 說明
公用方法 Grant(ServerPermissionSet, String) Grants the specified set of permissions to the specified grantee on the instance of SQL Server.
公用方法 Grant(ServerPermissionSet, array<String[]) Grants the specified set of permissions to the specified grantees on the instance of SQL 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 SQL Server.
公用方法 Grant(ServerPermissionSet, array<String[], Boolean) Grants access to the specified permission to the grantees and the ability to grant access to other users on the instance of SQL 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 SQL Server under an assumed role.
公用方法 Grant(ServerPermissionSet, array<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 SQL Server under an assumed role.

上層

備註

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.

請參閱

參考

Server 類別

Microsoft.SqlServer.Management.Smo 命名空間