Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Add a user with 'system' privs?
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)
Received on Sun Feb 13 2000 - 11:29:42 CST