Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

How to grant execute on stored procedure?

Asked by Camellia Kleiber Mar 20, 2023 2.0K views 1 answer
Share

About this question

 Normally when I create a stored procedure I use the following as a template of sort

Create procedure 
<@param1 , @param2 , etc..> 
as begin
 

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.

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.