General information
Title:
Application role and sp_oacreate permissions
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
Next
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