Microsoft

Hi,
I need to give assign spLog_Error execute permission for particular sql user,can you help how can i assign this permission for sql user so tht he can execute the stored Procedure.
SandeepiiiAsked:
Who is Participating?
 
Anthony PerkinsCommented:
Does the Stored Procedure use Dynamic SQL? If the answer is yes than in addition to EXECUTE permissions you will need explicit permissions for those Dynamic SQL commands.
0
 
Barry CunneyCommented:
GRANT EXECUTE ON spLog_Error TO [your_user]
0
 
SandeepiiiAuthor Commented:
good answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.