Enviado por Roger el día 22 de junio de 2006
Bueno hace unos dias instale la BD Oracle 10g, uego cree el repositorio para poder ocupar el Designer, el problema surge cuando quiero crear usuarios y que dichos usuarios puedan loguearse en el designer y crear sus propios diagramas, ya que no puedo ingresar si no tengo un repositorio para dicho usuario (ahora solo puedo entrar a Designer con Sysman ya que anteriormente cree un repositorio para el). Por lo tanto supuse que deberia crear como sysman el repositorio para el resto de los usuarios, al intentar crear el usuario Con el Repository Admin Utility ( click en el icono Maintain Users) luego me arroja el siguiente mensaje:
Message
-------
ORA-01031: insufficient privileges
--------------------------------------------------------------------------------
Message
-------
ORA-06512: at \\\\\\\\\\\\\\\"SYSMAN.JR_SYS_PRIVS\\\\\\\\\\\\\\\", line 236
--------------------------------------------------------------------------------
Message
-------
ORA-06512: at \\\\\\\\\\\\\\\"SYSMAN.JR_SYS_PRIVS\\\\\\\\\\\\\\\", line 120
--------------------------------------------------------------------------------
Message
-------
ORA-06512: at line 1
--------------------------------------------------------------------------------
Message
-------
RME-02124: Failed to execute SQL statement: Declare x number; begin rmmes.clear; x:= jr_sys_privs.ins (\\\\\\\\\\\\\\\'ROGER\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'ROGER\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'ROGER\\\\\\\\\\\\\\\', sdd_sys_priv_list(\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'Y\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'Y\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'Y\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'Y\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'Y\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'Y\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\'N\\\\\\\\\\\\\\\')); end;
--------------------------------------------------------------------------------
Espero me puedan ayudar he intentado varias cosas ya y no he tenido mucha suerte. Desde ya muchas gracias.
Salu2!
Foros de debate
Oracle
