permissions to user to send email
Posted on 2011-09-16
I have a stored procedure that sends email successfully when I'm logged in as sa.
But from one of my apps--with different credentials--I get an error about:
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.The EXECUTE permission was denied on the object 'sp_OASetProperty', database 'mssqlsystemresource', schema 'sys'.The EXECUTE permission was denied on the object 'sp_OASetProperty', database...
So I try to start doing what every link on the web--which you're about to post in as your answer--says to do. Like this:
grant exec on sp_OACreate to [rsuser1];
But that yields:
"Cannot find the user 'rsuser1', because it does not exist or you do not have permission."
The user does exist. It's a SQL account, not a domain account, but it does exist in SQL.
What do I need to do? I really need some specifics.