Wednesday, December 17, 2014

The EXECUTE permission was denied on the object 'sp_OACreate'

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OASetProperty] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OAMethod] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OAGetErrorInfo] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OADestroy] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OAStop] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OACreate] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OAGetProperty] TO [public]
GO

sp_configure 'show advanced options', 1
GO

reconfigure
go

exec sp_configure
go

exec sp_configure 'Ole Automation Procedures', 1
go

reconfigure

No comments: