StoredProcedure.Grant Method

Grants the specified set of permissions to the specified grantees on the stored procedure.

Remarks

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

Overload List

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

See Also

Reference

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

Other Resources

Granting, Revoking, and Denying Permissions
CREATE PROCEDURE (Transact-SQL)