November 29, 2004 at 9:41 am
I want to give my developer access to one of the store Procedure, the store procedure has an update and insert activity.
when I give him execute permission on that store procedure I am getting Error you don't have privileges on Insert and update.
Its SQL Authentication, is any way where I can avoid giving him access on tables for insert and update.
Thanks
Nita
November 29, 2004 at 10:08 am
Who owns the tables? If you own the tables and stored procedure, then you can grant execute on the procedure and the developer will be able to run it. If there are different owners, then you'd have to grant permissions to the table separately.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 29, 2004 at 10:39 am
Steve,
dbo is the owner of the table. And all the store procedure is to own by dbo.
But I give just execute permission it say denied on insert and update on sxy table
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply