Udostępnij za pośrednictwem


DatabaseRole.Grant Method

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

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Overload List

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

See Also

Reference

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

Other Resources

Granting, Revoking, and Denying Permissions
Managing Users, Roles, and Logins
Database Roles
CREATE ROLE (Transact-SQL)