Problema de ejecución de una sp

06/07/2004 - 20:09 por Ramon Zarza | Informe spam
Colegas

Al intentar ejecutar un SP que realiza varios Insert, con nivel de usuario
sencillo me devuelve el mensaje de abajo. Esto no ocurre al hacerlo como
administrador.

Esto sucede desde el SP3 de SQLServer. Ya le di en la base el check de
intercambiar chain (o algo asi) pero igaul me sigue dando el problema..

Algún consejo??

Saludos
****** Mensaje de error************

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 21
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 25
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 28
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 30
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 32
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 33
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 34
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 36
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 38
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OAGetErrorInfo, Line 43
EXECUTE permission denied on object 'sp_OAGetErrorInfo', database 'master',
owner 'dbo'.
sp_OAGetErrorInfo failed.
Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 21
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 25
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 28
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 30
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 32
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 33
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 34
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 36
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 38
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OAGetErrorInfo, Line 43
EXECUTE permission denied on object 'sp_OAGetErrorInfo', database 'master',
owner 'dbo'.
sp_OAGetErrorInfo failed.
 

Leer las respuestas

#1 Emilio Boucau \(en casa\)
07/07/2004 - 00:09 | Informe spam
Ramon,

es por derechos ... Esto esta tomado del Books On Line, de sp_OACreate:

Permissions
Only members of the sysadmin fixed server role can execute sp_OACreate.


Saludos !

Emilio Boucau
Buenos Aires - Argentina
http://www.portalsql.com

Preguntas similares