| Author |
 Topic  |
|
Stoad
Freaky Yak Linguist
*
1983 Posts |
 Posted - 02/22/2005 : 16:19:38
|
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? |
 |
|
|
Stoad
Freaky Yak Linguist
*
1983 Posts |
|
|
beyonder422
Posting Yak Master
USA
124 Posts |
Posted - 11/04/2005 : 16:51:48
|
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 |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 03/11/2008 : 16:56:50
|
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
|
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 03/11/2008 : 17:41:33
|
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 |
|
|
|
Topic |
|
|
|
xp_cmdshell execute right
