Grant as db_owner

[hydrorocks]

Hi,

I want a User that he can execute a procedure with db_owner rights. The user does not have the role db_owner, but he needs it for this procedure to work. So I tried this:

GRANT Execute ON myProcedure to myUserName as db_owner

But I get "Grantor does not have GRANT permission." back. What can I do so the user can execute the procedure with db_owner rights??

Any help is appreciated! Thanks.

 

[Juice05]

Open the stored procedure and click on the permissions button on the top right of the form. Find your user and give themm execute permission.

 

[hydrorocks]

That won't work, it only would work if I give hin the db_owner role which is to much power for the user. I already gave him execute permission on this procedure.

What I need is to give him the db_owner role for just this one procedure...

I think this is too hard to explain... I don't get it myself ;o)

 

[DrSql]

As suggested Juice05 you can grant execute permission on it, but you might be accessing some system objects. So go through the SP and see which objects are used in the SP. Then grant permissions to thos objects.

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[Juice05]

Post your stored procedure's code.