开发反馈程序遇到如下报错
The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.
The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
The EXECUTE permission was denied on the object 'sp_OADestroy', database 'mssqlsystemresource', schema 'sys'.
解决方法:在master库创建对应用户,并加报错存储过程执行权限
USE [master]
GO
CREATE USER [myuser] FOR LOGIN [myuser];
GRANT EXECUTE ON SYS.sp_OACreate TO [myuser];
GRANT EXECUTE ON SYS.sp_OAMethod TO [myuser];
GRANT EXECUTE ON SYS.sp_OADestroy TO [myuser];
参考