Re: how do I allow usera to create tables in userb's tablespace?

Lee Farrant wrote:
>
> how do I allow usera to create tables in userb's tablespace?

This is an extremely easy qustion, so why don't you read the excellent Oracle documentation?

Answer: No user "owns" a tablespace. He just has quotas on it (limited or unlimited). Thus allowing a user to create a table on a tablespace is equivalent to giving him quota.

U.

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!