Solved

Multiple Grant Statements in SP

Posted on 1998-07-07
2
199 Views
Last Modified: 2010-03-19
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
Comment
Question by:vd
2 Comments
 
LVL 7

Accepted Solution

by:
spiridonov earned 50 total points
ID: 1091678
Separate each GRANT statement with 'go' keyword
0
 

Author Comment

by:vd
ID: 1091679
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now