permissions required for CDOSys stored procedures

[divinyl]

Hi there

I'm doing some analysis on the database applications in my organisation before migrating the databases to a new server. One of these makes use of CDOSys objects for sending mail, instead of SQL Mail. There are a number of stored procedures within the database that call the sp_OACreate & sp_OASetProperty. Apparently only members of the sysadmin role can execute these stored procedures, however, the sql login for this application is not a sysadmin! I thought perhaps there was a mistake in books online but i've looked on google and the permission requirements are the same - must be sysadmin. Any ideas how it still manages to function without these rights?

Thanks in advance!

 

[ptheriault]

This is a duplicate post. I have answered this question in SQL Setup and Admin.

- Paul

- If at first you don't succeed, find out if the loser gets anything.