About this question
Normally when I create a stored procedure I use the following as a template of sort
Create procedure<@param1 , @param2 as begin, etc..>
end
Is there a way to include granting execute permission on only that stored procedure while I'm at it?
For instance like ...
Grant execute [User_Execute]
... but only for this stored procedure?
I've seen some other similar questions but they seem to all refer to ALL of the stored procedures and not just one, nor have I seen one where you can specify permissions inside of the create procedure script. Even answers about how I can set permissions without the GUI for specific stored procedures would be welcome.