[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

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?
0
vd
Asked:
vd
1 Solution
 
Victor SpiridonovCommented:
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

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now