Re: Oracle Create User Problem

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F4B90E8.6939064E_at_exxesolutions.com>...
> 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>
> PROFILE DEFAULT;
User will have all privileges on the tablespaces specified in 'Quota ? ON tb2'?
Will the privileges be the same as if we have created the tablespaces after login-into User instead of system/manager?

Is it good to have one default and temp tablespace? and not use to create project related tables? and Have project specific on the different tablespaces?

correct me??
Thanks Received on Wed Aug 27 2003 - 00:29:01 CDT