Re: how to create a new user

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/04/10
Message-ID: <8cr9ji$6cm$1@perki.connect.com.au>#1/1

CREATE USER "user0"
IDENTIFIED BY "user0"
DEFAULT TABLESPACE "USR"
TEMPORARY TABLESPACE "TEMP"
PROFILE DEFAULT
ACCOUNT UNLOCK; table spaces USR and TEMP will be the default table spaces for this user. You also need to grant connect to this user.

Tom

--
Sunil Pandey <sunny_at_cse.iitb.ernet.in> wrote in message
news:slrn8evasd.at6.sunny_at_everest.cse.iitb.ernet.in...


> hello world..

>

>         can someone pls tell me how to create a new user for using a

> database. I am using oracle 8i on linux

>

> thanx in advance.

> sunil

Received on Mon Apr 10 2000 - 00:00:00 CDT