Schema.Grant Method

Grants the specified set of permissions to the specified grantees on the schema.

備註

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

多載清單

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

請參閱

參考

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

其他資源

Granting, Revoking, and Denying Permissions
瞭解資料庫結構描述
CREATE SCHEMA (Transact-SQL)