Re: Tablespace

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Mon, 23 Apr 2001 15:07:24 +0100
Message-ID: <988034885.21035.0.nnrp-14.c30bdde2@news.demon.co.uk>

alter user username quota unlimited on table_space1. alter user username quota 0k on table_space2. etc?

"Thomas Durlach" <durlecht_at_msu.edu> wrote in message news:9c16n9$vm6$1_at_msunews.cl.msu.edu...
> 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
>
>
Received on Mon Apr 23 2001 - 09:07:24 CDT