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