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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement