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 |
|
beyonder422
Posting Yak Master
124 Posts |
 Posted - 2005-11-04 : 17:00:50
|
| Anyone know why I can't send a SQL email with a created user with "execute" permissions?"EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'"I've got it nicely wrapped in a proc and have given my web_user login permission to execute that proc.Is there a simple way to resolve this? And have also seen this: http://support.microsoft.com/kb/q224945,but I'm trying to call it from a web page...How can I execute 'sp_OACreate' with a baseline user? |
|
|
beyonder422
Posting Yak Master
124 Posts |
Posted - 2005-11-08 : 12:35:07
|
answered my own question.must grant user specific "EXECUTE" permissions to these system procs found in the master database, "Extended Stored Procedures" list.sp_OACreate, sp_OAGetProperty, sp_OASetProperty, sp_OAMethod, sp_OAGetErrorInfo, sp_OADestroyDidn't look in there....... be sure to add the user from your app db to the master db users list.in my situation I had to grant "EXECUTE" perms to all of these procs to successfully and cleanly send a SQL email |
 |
|
|
|
|
|
EXECUTE permission denied on object sp_OACreate