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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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
 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.04 seconds. Powered By: Snitz Forums 2000