Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sysman Insufficient Privileges

462239Jun 19 2006 — edited Jun 20 2006
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2006
Added on Jun 19 2006
3 comments
5,332 views