Sysman Insufficient Privileges
462239Jun 19 2006 — edited Jun 20 2006Hi everyone,
My Problem: I create a repository for sysman user in oracle database 10g R1, well
now i want to connect to my database with Oracle designer but i can´t log with (for example user1), designer says something like that: you need to create a repository for user1.
I log in Repository admin tool as sysman and i create a user (user1), click in Maintai User icon, maybe with that i can log in designer but Repository Admin Tool says:
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;
--------------------------------------------------------------------------------
And i don´t know undestand :(:(...What privileges i nedd as sysman to create repository to any user. i want to log in designer as user1.. thanks in atvance.