Setting permissions for SP_OACreate

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Setting permissions for SP_OACreate

Author

Topic

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-08-27 : 13:47:14

Hello,
am trying to run an XMLHTTP request on our 2005 db server.

Am using the following code. But get a permissions error.

1. How do i set the permissions ?
2. Does anyone have any url link to any documentation on the XMLHTTP object ?

thanks
Ehi

Exec @nError = sp_OACreate 'Microsoft.XMLHTTP', @iReq OUT

Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 1
The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-27 : 14:16:47

you need to GRANT execute right on this sp for the user in schema sys.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources