[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Multiple Grant Statements in SP

Posted on 1998-07-07
2
Medium Priority
?
232 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
Victor Spiridonov earned 150 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
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
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

656 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