March 13, 2009 at 11:43 pm
Hi,
This is my first time using SQL management studio. How do I set execute permissions for the stored procedures? I double click on the user, I select Securables form the new pop-up window. I select all objects of type stored procedures and check Execute permissions and click Ok. Then I visit my webpage, I still get the Execute permission denied error. I go back to the Securables window, it is empty. How do I grant execute permissions to a list of sprocs for a given user??????????
Thanks.
March 14, 2009 at 8:19 am
Sounds like it should work. Try this instead of using the GUI:
GRANT EXECUTE ON OBJECT::schema.procedurename TO username
Then try the specific stored procedure. You could also try logging into the server using SSMS as the user and try executing the procedure in a query window.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 14, 2009 at 1:13 pm
I tried to login to SSMS using sql auth, I got this error -
A connection was successfully established with the server, but then an error occurred during the login process (No process is on the other end of the pipe)
GRANT EXECUTE ON... command worked.
March 16, 2009 at 7:05 am
Here is a search link that may have some results that help.
Here is the first link from that search that may help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply