Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chedderslam
Posting Yak Master
223 Posts |
 Posted - 2008-06-12 : 10:13:37
|
| What role does a user have to be in to execute a stored procedure?I am trying to run an exec statement from a web app and am getting "The EXECUTE permission was denied".Thanks. |
|
|
chedderslam
Posting Yak Master
223 Posts |
Posted - 2008-06-12 : 10:22:18
|
| I can execute other stored procedures, just not the one I just created. Why would that be? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 10:32:03
|
| What's the context under which you're executing it? |
|
|
|
chedderslam
Posting Yak Master
223 Posts |
Posted - 2008-06-12 : 10:36:48
|
| It's a call from a web app logged into an account I created.I looked at the permissions properties of the other stored procedures and this one. The other stored procedures have the public role with execute permission. The stored procedure I created has nothing under permission properties. I added the public role and gave it execute permissions and now it works. But that would mean that I have to go in and add the public role every time I create a new stored procedure. Is that normal or am I doing something wrong?Thanks. |
|
|
|
|
|
|
stored procedure permissions