Re: Rights to a Tablespace

mikedborden_at_my-deja.com wrote:
>
> I'm a newbie so don't kill me.
> I had a vendor to tell me to give a user read rights to a tablespace. I
> don't think you can do a tablespace can you? Also, I do try to give the
> user rights as system to the individual tables in the table space and it
> keeps saying that I have insufficient privileges. Is this because the
> table space was created by another user? How do I assign this user to
> the tables without doing each individual tables, a script?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

The vendor is mistaken...

You can give rights to objects WITHIN the tablespace (tables) and you can give quotas on the tablespace to allow creation of objects in that tablespace..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse