[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Grantor does not have GRANT permission error

Posted on 2006-05-19
Medium Priority
Last Modified: 2008-01-09
hi all,

i am trying to do this


i get an error like this;

Grantor does not have GRANT permission.

what am i doing wrong?
Question by:lytung818
LVL 15

Expert Comment

ID: 16721809
What ID are you logged in with?  The message means you do not have GRANT permission on sp_makewebtask
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 600 total points
ID: 16721815
the user you are connected with does have the permission to execute the procedure, but does not have the permission to grant the permission further.
you have to either get that admin permissions to the user you are currently logged on with, or login with a user that has that permission for that procedure (ie the procedure owner)
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 400 total points
ID: 16723179
From BOL

The user must have SELECT permissions to run the specified query and CREATE PROCEDURE permissions in the database in which the query will run. The SQL Server account must have permissions to write the generated HTML document to the specified location. Only the members of the sysadmin fixed server role can impersonate other users.

Perhaps now you should reconsider and use a front-end app as I suggested orginally.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

834 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