Re: Create new users

From: Breno de Avellar Gomes <brenogomes_at_computer.org>
Date: Sat, 17 Apr 1999 12:27:33 +0100
Message-ID: <37187025.C25776B4@computer.org>

Hi Johan

The basic syntax to create users in Oracle8 is:

CREATE USER "THEUSER" IDENTIFIED BY "thepassword" DEFAULT TABLESPACE "USER_DATA" TEMPORARY TABLESPACE "TEMPORARY_DATA" PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT "CONNECT" TO "THEUSER";
GRANT "RESOURCE" TO "THEUSER";
GRANT UNLIMITED TABLESPACE TO "THEUSER"; ALTER USER "THEUSER" DEFAULT ROLE ALL; replace "THEUSER" and the password as appropriate - double quotes are part of syntax.

In order to give access to db1 use
GRANT "CONNECT" ON username.db1 TO "THEUSER" where username is the user who created the table

Send me an email for more details

Johan den Boer wrote:

> Hello,
>
> I am a newbie in oracle. How can you add a user to the database and
> how do you give access to a database. Suppose you have two
> databases db1 and db2. How do you give access to only database db1
> and not to db2. Is there a tool in oracle ?
>
> Please send me email to jj.den.boer_at_hccnet.nl
>
> Thanks a lot
Received on Sat Apr 17 1999 - 06:27:33 CDT