Share via


Schema.Grant Method

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

Remarks

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

Overload List

Name 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.

See Also

Reference

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

Other Resources

Granting, Revoking, and Denying Permissions
Understanding the Database Schemas
CREATE SCHEMA (Transact-SQL)