Colegas..
Realice la actualización del SQL con SP3 y a partir de ese momento los
uusarios de un sistema no pueden ingresar a realizar un INSERT
Todos los usuariso son simples ususarios de la red de W2K
la seguridad del SP es por intregracion con el Windows.
personalmente asigno los permisos necesarios al grupo que puede realizar la
actividad.
pero me devuelve este error. Y ocuure desde la actualizacion del SP3.. antes
todo funcionaba muy bien
Alguien tiene idea de que puede pasar...
Agradezco su ayuda --
Les dejo el mensaje de error
Saludos
*********************************************
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 27
EXECUTE permission denied on object 'sp_OACreate', 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 36
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 39
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 42
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 43
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 44
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 47
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 49
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 55
EXECUTE permission denied on object 'sp_OAGetErrorInfo', database 'master',
owner 'dbo'.
sp_OAGetErrorInfo failed.
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 27
EXECUTE permission denied on object 'sp_OACreate', 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 36
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 39
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 42
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 43
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 44
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 47
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 49
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 55
EXECUTE permission denied on object 'sp_OAGetErrorInfo', database 'master',
owner 'dbo'.
sp_OAGetErrorInfo failed.
(1 row(s) affected)
(1 row(s) affected)
Leer las respuestas