Multiple Grant Statements in SP

When I attempt to create a stored procedure that contains more than one GRANT statement , it appears to execute
OK but the actual stored procedure shows only the first GRANT statement. How can I create a stored procedure
that lets me issue  multiple GRANT statements?
vdAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Victor SpiridonovConnect With a Mentor Commented:
Separate each GRANT statement with 'go' keyword
0
 
vdAuthor Commented:
I did separate the GRANT statements with the GO keyword! (Which was not working)
It works if you omit all the GO keywords expect the last one.
Since your response was quick and your comment basically got me
thinking about the significance of GO, you can have the points anyway!


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.