Grantor does not have GRANT permission error

hi all,

i am trying to do this

GRANT EXECUTE ON sp_makewebtask TO PUBLIC

i get an error like this;

Grantor does not have GRANT permission.


what am i doing wrong?
lytung818Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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)
0
 
DonKronosCommented:
What ID are you logged in with?  The message means you do not have GRANT permission on sp_makewebtask
0
 
Anthony PerkinsCommented:
From BOL

<quote>
Permissions
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.
</quote>

Perhaps now you should reconsider and use a front-end app as I suggested orginally.
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.