This topic has not yet been rated - Rate this topic

Server.Grant Method

SQL Server 2012

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

This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.

Overload List

	Name	Description
	Grant(ServerPermissionSet, String)	Grants the specified set of permissions to the specified grantee on the instance of SQL Server.
	Grant(ServerPermissionSet, 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, 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, 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.

Top

Remarks

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.

Reference

Server Class

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD