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 |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-08-09 : 13:35:52
|
| there is 3 stored procedures for our system.on that 1 stored procedure when i tried to call from ASP page, it's throwing me an error like " Execute permission denied on object <stored procedure name>".why i am getting this kind of error.thanks in advance |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-09 : 14:00:02
|
| You are getting this error because you don't have permission to EXEC the stored procedure. Contact the DBA to have him/her add it.Tara |
 |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2005-08-09 : 14:22:30
|
| It could also be that you left a GO statement out of your script which would then compile the execute permissions into the stored proc instead of granting the permission to the specific user.Can you post the code including the permission line?AjHey, it compiles. |
|
|
|
|
|
|
execute permission denied