Re: Tablespace

From: Pierre HIRTH <p.hirth_at_sbm.mc>
Date: Mon, 23 Apr 2001 16:00:51 +0200
Message-ID: <9c1cjm$a1i$1@news4.isdnet.net>

hi,
I think it was the default close when you created user

CREATE USER X BY VALUES x

DEFAULT TABLESPACE table_space1

"Thomas Durlach" <durlecht_at_msu.edu> a écrit dans le 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:00:51 CDT