Últimos mensajes - Powered by IBM

Palabras claves

Problemas posteriores al SP3

07/06/2004 - 16:55 por Ramon Zarza | Informe spam

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)

Siga el debate

3 respuestas

Tengo una respuesta

Preguntas similare

Leer las respuestas

#1 Maxi

07/06/2004 - 17:11 | Informe spam

Hmmm y ese Store que hace?

Salu2
Maxi
Buenos Aires - Argentina
Desarrollador Microsoft 3 Estrellas .NET
Nunca consideres el estudio como una obligación sino como
una oportunidad para penetrar en el bello y maravillosos
mundo del saber.
- Albert Einstein

"Ramon Zarza" escribió en el mensaje
news:u%

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

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)

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004

Responder a este mensaje

#2 Javier Loria

07/06/2004 - 18:20 | Informe spam

Hola Ramon:
Es posible que cuando aplicaras el SP quedara la opcion deshabilitada de
CROSS-DATABASE CHAINING. Al hacer esto lo que ocurre es que ser revisaran
los permisos de los usuarios no solo para ejecutar el procedimiento que
estas corriendo sino los permisos de los usuarios sobre los objetos que
pertenecen a otras bd (en este caso master).
Te quedan dos alternativas, activar CROSS-DATABASE CHAINING, que no es
recomendado por MS por que puede constituir un problema de seguridad. Para
hacer esto lo puedes hacer en el servidor clic derecho, seguridad habilitas
el CHECK de allow cross-database chaining. O lo puedes hacer por BD clic
derecho properties opciones y marcas la misma opcion.
La segunda alternativa, considerada mas segura es dar permisos a los
usuarios sobre estos procedimientos, en este caso debes crear al grupo como
usuario de la BD de master y luego dar los permisos apropiados.
Saludos,

Javier Loria
Costa Rica
Se aprecia la inclusion de DDL (CREATE, INSERTS, etc.)
que pueda ser copiado y pegado al Query Analizer.
La version de SQL y Service Pack tambien ayuda.

Ramon Zarza escribio:

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)

Responder a este mensaje

#3 Ramon Zarza

08/06/2004 - 04:06 | Informe spam

(por pagina web ya que me encuentro fuera)

Ese store reliza varios INSERT en varias tablas

Saludos

Hmmm y ese Store que hace?

Salu2

Maxi
Buenos Aires - Argentina
Desarrollador Microsoft 3 Estrellas .NET

Nunca consideres el estudio como una obligación sino como
una oportunidad para penetrar en el bello y maravillosos
mundo del saber.
- Albert Einstein

"Ramon Zarza" escribió en el mensaje
news:u%

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)

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system

(http://www.grisoft.com).

Version: 6.0.698 / Virus Database: 455 - Release Date:

02/06/2004

.

Siga el debate Respuesta

Responder a este mensaje

Ads by Google

Hacer una pregunta

Tengo una respuesta

Busqueda sugerida