Re: Add a user with 'system' privs?

Brice,
 there is always a 'SYS' account. This is the owner of all Oracle internal objects (data dictionary etc.)  Default password is 'change_on_install'.

 You should not need to logon as SYS, SYSTEM (or DBA for that matter) has all the grants you would need for regular administration.

Karsten

In article <38A70D3B.705C3837_at_penguinboots.com>,   Brice Ruth <Brice.Ruth_at_penguinboots.com> wrote:
> 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)
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 14 2000 - 02:55:16 CST