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;
Thanks! Morgan.
I am able to create user with your suggestion.
How to see, who is the owner of the tablespace? if, i don't specify
"Quota ? on tb1", User won't be able to access tb1.
Please correct me?
Received on Wed Aug 27 2003 - 02:03:55 CDT
