DatabaseRole.Grant Method

Include Protected Members
Include Inherited Members

Grants the specified set of permissions to the specified grantees on the database role.

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
Public method Grant(ObjectPermissionSet, String) Grants the specified set of permissions to the specified grantee on the database role.
Public method Grant(ObjectPermissionSet, array<String[]) Grants the specified set of permissions to the specified grantees on the database role.
Public method Grant(ObjectPermissionSet, String, Boolean) Grants access to the specified permission to the grantee and the ability to grant access to other users on the database role.
Public method Grant(ObjectPermissionSet, array<String[], Boolean) Grants access to the specified permission to the grantees and the ability to grant access to other users on the database role.
Public method Grant(ObjectPermissionSet, 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 database role under an assumed role.
Public method Grant(ObjectPermissionSet, 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 database role under an assumed role.

Top

See Also

Reference

DatabaseRole Class

Microsoft.SqlServer.Management.Smo Namespace