Re: 8i accessing to Enterprise Manager

Frederic,

All of the replies to this thread assume you have been able to create the repository, but I suspect you are running into a problem during repository creation. If you have an existing user that you are trying to use as the repository owner, you must grant the user the required system privileges. Simply granting the DBA role to this user will not work. Now the bad news...I'm at home, and I don't remember which privileges are require...I think:

connect (I know...I know...this is a role), create trigger, create procedure, execute any procedure, and maybe select any table.

Now, if you let the EMCA create a new user to be the repository owner, it will grant these privileges (and role) to the user, and you won't get the message.

Marty

frederic brouard <frederic.brouard_at_mediane.tm.fr> wrote in message news:3bdfc121$0$14592$4d4eb98e_at_read.news.fr.uu.net...
> Hello there,
>
> We have just install an Oracle 8i with the default option creating default
> admin user.
>
> Now we are stopped by the Enterprise Manager asking us for an user with
> correct rigths to use it but we don't know wich is the good one.
>
> Any help will be appreciate.
>
> Thanks in advance
>
> --
> Fred BROUARD - French web site SQLpro : topic is SQL -
> http://sqlpro.multimania.com
> Book "SQL développement" Campus Press 2001 -
> http://sqlpro.multimania.com/bookSQL.html
> Paradox expert, Delphi specialist http://perso.club-internet.fr/brouardf
>
>
>
>
>
Received on Wed Oct 31 2001 - 16:51:46 CST