Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Users
Thank you very much for you help
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3CEA7C89.2EA49DAC_at_exesolutions.com...
> "A.K" wrote:
>
> > Newbie question?
> > Dear All,
> >
> > How can i add users like "scott" to connect to oracle8i server with the
same
> > permissions?
> >
> > Thanks in advance.
>
> I'd start with reading the manual because this is a really basic question.
If
> you have no manuals or books try:
>
> http://technet.oracle.com
> http://tahiti.oracle.com
> http://docs.oracle.com
>
> To create a user with Scott's permissions in any database you must assign
> tablespaces for objects and temp. To do so requires knowing what
tablespaces are
> available:
>
> Connect as SYS or SYSTEM and ...
>
> SELECT tablespace_name
> FROM dba_tablespaces;
>
> Do not use SYSTEM for anything. Same goes for anything like RBS which
hopefully
> contains rollback segments.
>
> Likely you will end up with something like:
>
> CREATE USER scott
> IDENTIFIED BY tiger
> DEFAULT TABLESPACE users
> TEMPORARY TABLESPACE temp
> QUOTA UNLIMITED ON users;
>
> Then:
>
> GRANT CONNECT TO scott;
>
> Daniel Morgan
>
Received on Tue May 21 2002 - 13:08:38 CDT