SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 xp_cmdshell execute right
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Stoad
Freaky Yak Linguist

*
1983 Posts

Posted - 02/22/2005 :  16:19:38  Show Profile  Visit Stoad's Homepage  Reply with Quote
I am still waiting for confirmation of my recent "discovery" to be true.
I mean what if my SQL Server 7.0 went slightly mad?
Go to Top of Page

Stoad
Freaky Yak Linguist

*
1983 Posts

Posted - 03/15/2005 :  14:18:12  Show Profile  Visit Stoad's Homepage  Reply with Quote
Nobody nosed me to something like this KB article:
http://support.microsoft.com/?kbid=810474 ......
Go to Top of Page

beyonder422
Posting Yak Master

USA
124 Posts

Posted - 11/04/2005 :  16:51:48  Show Profile  Reply with Quote
so what the hell is the concensus on this issue?

"EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'"

I've got it nicely wrapped in a proc and have given my web_user login permission to execute that proc.

Is there a simple way to resolve this?
And have also seen this: http://support.microsoft.com/kb/q224945,
but I'm trying to call it from a web page...

Scr3w the cmdshell bit, how can I execute 'sp_OACreate'?

Edited by - beyonder422 on 11/04/2005 16:53:49
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 03/11/2008 :  16:56:50  Show Profile  Reply with Quote
I get

quote:

Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 4
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 5
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OADestroy, Line 7
EXECUTE permission denied on object 'sp_OADestroy', database 'master', owner 'dbo'.



So you do have to be sa?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 03/11/2008 :  17:41:33  Show Profile  Reply with Quote
quote:
Originally posted by X002548

I get

quote:

Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 4
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 5
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OADestroy, Line 7
EXECUTE permission denied on object 'sp_OADestroy', database 'master', owner 'dbo'.



So you do have to be sa?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam







From SQL Server 2000 BOL:
"Only members of the sysadmin fixed server role can execute sp_OACreate."

From SQL Server 2005 BOL:
"Requires membership in the sysadmin fixed server role"

If you are using SQL 2005, you may be able to workaround this using a stored procedure with the EXECUTE AS clause.



CODO ERGO SUM
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000