Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Just Installed But Now Shrugging
do NOT use username SYSTEM to create any tables, and do NOT create any tables in the SYSTEM tablespace.
(note: oracle will let you do this, but you'll regret it later.)
instead, create a user, set tablespace quotas for the user, and grant appropriate privileges to the user, and connect as the new user to start creating tables.
for an example, see the SCOTT username/schema.
"Michael B. Allen" <mballen_at_erols.com> wrote in message
news:slrn9jb7s8.4f5.mballen_at_nano.foo.net...
> Spencer wrote:
> >i've never had a need to connect as dbaoper... an
>
> Oops, I meant 'sysoper'. It's referenced in the Oracle8i Administrator's
> Reference anyway.
>
> >as you get into it, you will find that both SYS and
> >SYSTEM are usernames with powerful privileges,
> >powerful enough to essentially destroy the database.
> >be VERY careful when logged on as either. when
> >either username will do, then use SYSTEM.
>
> Should SYSTEM be used to create normal non-system tables? Or should I
> grant that capacity to a privledged user?
>
> Well, I have purchased The Complete Reference so I'll just do a little
> reading for a while.
>
> Thanks,
> Mike
>
Received on Wed Jun 27 2001 - 23:57:34 CDT