StoredProcedure.Grant Method

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

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

CREATE PROCEDURE (Transact-SQL)