Re: Oracle Create User Problem

Rajesh wrote:

> I have a script to create all the tablepaces from tb1 to tb4.
>
> And when i run the below create user script, I get the error in the
> sql option.
> Are the below line is synataxically wrong, anybody please suggest?
>
> CREATE USER <username> IDENTIFIED BY <password> DEFAULT TABLESPACE
> tb1, tb2, tb3, tb4 PROFILE DEFAULT;
>
> Whether it hold good for both Oracle 8i and 9i?
>
> Thanks in advance.

CREATE USER <user_name>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <pick_just_one>
TEMPORARY TABLESPACE <temp>
QUOTA 0 ON SYSTEM

QUOTA ? ON <tablespace_name>
QUOTA ? ON <tablespace_name>
QUOTA ? ON <tablespace_name>
QUOTA ? ON <tablespace_name>

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)