Thank you Cetin,
We decided to create a separate connection to skip the application role.
Thanks,
>>Hello,
>>
>>
>>My database Data1 allows connections through an application role for all users but some stored procedures need to execute sp_OACreate extended stored procedure and the sql system returns this error:
>>
>>The execute permission was denied on the object 'sp_OACreate' , Database mssqlsystemresource, schema sys.
>>
>>This seems to be a permissions issue but don't know how to solve it.
>>
>>Any ideas,
>>Thanks,
>>
>>Juan C. Jaramillo
>
>Juan,
>"Permissions
>Only members of the sysadmin fixed server role can execute sp_OACreate."\
>In 2005 if you allow OLE you could workaround with runas I think.
>Cetin
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only