Re: Add a user with 'system' privs?

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 - 13:59:55 CST