Re: Creating Users

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 21 May 2002 16:57:57 GMT
Message-ID: <3CEA7C89.2EA49DAC@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 - 11:57:57 CDT