Re: Setup and create user?

From: Brett England <brett_at_recalldesign.com>
Date: 2000/04/11
Message-ID: <38F27D5F.625A42B1@recalldesign.com>#1/1

As a DBA:
alter user <your user> quota unlimited on <new>; OR for access to any tablespace in your database grant unlimited tablespace to <your user>

Yep you only get 1 default tablespace that doesn't mean you can access others.
ie create table x (x varchar(1)) tablespace <new>;

lkj741_at_my-deja.com wrote:

> How can I create a user that can access to three different tablespaces?
>
> When I create a user I can only assign to one default tablespace.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 11 2000 - 00:00:00 CDT