Re: OEM Configuration(privs error)

Eric,

GRANT "CONNECT" TO "your_user";
ALTER USER "your_user" DEFAULT ROLE ALL GRANT CREATE PROCEDURE TO "your_user";
GRANT CREATE TRIGGER TO "your_user";
GRANT EXECUTE ANY PROCEDURE TO "your_user"; GRANT SELECT ANY TABLE TO "your_user";

Note, the user must have these privileges granted explicitly, not through a role (e.g. DBA)

See the following doc on MetaLink for more details:

Note 108063.1 - "Existing user Lacks privileges or roles when creating OEM 2.1 repository"

BTW, it is not recommended to use INTERNAL/SYS as the OEM repository owner as this creates the OEM repository in the system tablespace.

HTH,

• Anita
  • ARUN K C <arun_k_c_at_hotmail.com> wrote:
    > I dont about hpw but one way which I have done is
    > logged in as sys and then
    > create then create the repository user, this is
    > working fine on Sun and NT,
    > did you try logging in as sys
    >
    >
    > >From: Eric Fang <eric_fang_at_yahoo.com>
    > >Reply-To: ORACLE-L_at_fatcity.com
    > >To: Multiple recipients of list ORACLE-L
    > <ORACLE-L_at_fatcity.com>
    > >Subject: OEM Configuration(privs error)
    > >Date: Wed, 05 Jul 2000 17:04:56 -0800
    > >
    > >I just downloaded the lastest OEM2.1 from technet.
    > But
    > >I got an error when try to run a configuration
    > >assistant at step 3 of 5: the user lacks one or
    > more
    > >of the privileges or roles required to create and
    > >support a management server repository.
    > >What kinda privs does should this user have? (I
    > >granted DBA and sysadmin to this user).
    > >Also any idea or docs on hpw to configure the
    > >management server? Thanks in Advance.
    > >
    > >Eric Fang
    > >
    > >__________________________________________________
    > >Do You Yahoo!?
    > >Send instant messages & get email alerts with
    > Yahoo! Messenger.
    > >http://im.yahoo.com/
    > >--
    > >Author: Eric Fang
    > > INET: eric_fang_at_yahoo.com
    > >
    > >Fat City Network Services -- (858) 538-5051
    > FAX: (858) 538-5051
    > >San Diego, California -- Public Internet
    > access / Mailing Lists
    > >--------------------------------------------------------------------
    > >To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > >to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > >the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > >(or the name of mailing list you want to be removed
    > from). You may
    > >also send the HELP command for other information
    > (like subscribing).
    >
    >

    ---

    
    > Get Your Private, Free E-mail from MSN Hotmail at
    > http://www.hotmail.com
    >
    > --
    > Author: ARUN K C
    > INET: arun_k_c_at_hotmail.com
    >
    > Fat City Network Services -- (858) 538-5051 FAX:
    > (858) 538-5051
    > San Diego, California -- Public Internet
    > access / Mailing Lists
    >

    ---

    
    > To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > (or the name of mailing list you want to be removed
    > from). You may
    > also send the HELP command for other information
    > (like subscribing).
    

    ---