Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: OEM Configuration(privs error)

Re: OEM Configuration(privs error)

From: ARUN K C <arun_k_c_at_hotmail.com>
Date: Thu, 06 Jul 2000 07:25:32 PDT
Message-Id: <10550.111340@fatcity.com>


if you are using oem configuration assistant then you can login as sy and create a new user with a different tablespace to choose also This I have done it and is working fine in my sun solaris and nt operating system
Well if you are going to manually going to create the repository then yes you will have to grant all the privilages which the oem repository needs

>From: "A. Bardeen" <abardeen1_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: OEM Configuration(privs error)
>Date: Thu, 06 Jul 2000 06:05:26 -0800
>
>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).
>
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: A. Bardeen
> INET: abardeen1_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).


Received on Thu Jul 06 2000 - 09:25:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US