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

Home -> Community -> Usenet -> c.d.o.server -> Re: Add a user with 'system' privs?

Re: Add a user with 'system' privs?

From: spencer <spencerp_at_swbell.net>
Date: Sun, 13 Feb 2000 20:17:48 -0600
Message-ID: <5AJp4.1426$tT6.35132@news.swbell.net>


if you haven't changed them:
the password for SYS is CHANGE_ON_INSTALL the password for SYSTEM is MANAGER

"Brice Ruth" <Brice.Ruth_at_penguinboots.com> wrote in message news:38A70D3B.705C3837_at_penguinboots.com...
> Hi there, Oleg.
>
> Thanx for your reply. However, my ORACLE_SID is set to '8idb'
and the instance
> name is 8idb. tnsping works fine, sqlplus connects fine as
system/manager and
> running svrmgrl; connect internal is fine, too.
>
> What's up with this?? Am I just missin' something here?
>
> Brice
>
> Oleg Fedorenkov wrote:
>
> > Hi!
> > If my understanding of the problem is correct, during
install WebDB asks a
> > password for SYS.
> > If environment variable ORACLE_SID (on NT it maybe registry
key) not set to
> > your SID (where WEBDB must be installed) you might not
connect to your
> > database during install and
> > WebDB cannot install it's packages, so installation is
cancelling.
> > Best regards,
> > Oleg Fedorenkov
> >
> > Brice Ruth <Brice.Ruth_at_penguinboots.com> wrote in message
> > news:38A6EA05.3CDC11E9_at_penguinboots.com...
> > > Hello, GC.
> > >
> > > The problem is I can't even create the user account in
question ... don't
> > > know how. I have a 'Beginner's Guide' to Oracle 8i, which
unfortunately
> > > depends heavily on WebDB being installed. Unfortunately,
WebDB appears to
> > > need access to the "SYS" account (which I imagine would be
similar to the
> > > "SYSTEM" account that currently exists). So - I need to
create an Oracle
> > > account called "SYS" so that the WebDB install can
complete correctly.
> > Any
> > > ideas??
> > >
> > > Thank you,
> > > Brice
> > >
> > > GC wrote:
> > >
> > > > Brice Ruth wrote:
> > > > >
> > > > > Greetings.
> > > > >
> > > > > In the abscence of assistance with installing WebDB,
could someone
> > point
> > > > > me to some info on how to add a user (without using
WebDB) to my
> > > > > database with the same priviliges as the 'SYSTEM'
account? I think
> > that
> > > > > would help me get through the WebDB install which
would set me on my
> > way
> > > >
> > > > You could grant dba to the user in question. Or check
out the various
> > > > roles system has. Remember to make sure the user being
granted these
> > > > privs has a default tablespace other than system.
> > > >
> > > > Cheers,
> > > > GC
> > >
> > > --
> > > +--+
> > > "The use of COBOL cripples the mind; its teaching should,
> > > therefore, be regarded as a criminal offense."
> > > -- E. W. Dijkstra (1982)
> > >
> > >
> > >
>
> --
> +--+
> "The use of COBOL cripples the mind; its teaching should,
> therefore, be regarded as a criminal offense."
> -- E. W. Dijkstra (1982)
>
>
>
>
Received on Sun Feb 13 2000 - 20:17:48 CST

Original text of this message

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