共用方式為


DatabaseRole.Grant Method

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

備註

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

多載清單

名稱 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.

請參閱

參考

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

其他資源

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