Re: Tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 23 Apr 2001 17:43:08 +0200
Message-ID: <3aj8etclnlpc5p1iotcs8lvged64r6ndh5@4ax.com>

On Mon, 23 Apr 2001 08:25:47 -0400, "Thomas Durlach" <durlecht_at_msu.edu> wrote:

>I have a quick question hopefully someone can answer....i have created 10
>tablespaces......and i want user X to be able to use table_space1,
>table_space2, table_space3.....how do i create a privilege for those
>tablespaces....i know if i grant resource to user X, everything will work
>fine...but i don't want that user to be able to access those other
>tablespaces....
>
>thanks,
>
>timis
>

Instead of *privilege* read *quota* in this particular instance. You need to alter the user to give him sufficient quota by issuing
alter user <username> quota <number>|unlimited ...

Hth,'
Sybrand Bakker, Oracle DBA Received on Mon Apr 23 2001 - 10:43:08 CDT