Re: tablespaces & schemas

From: Dave <x_at_x.com>
Date: Sun, 17 Apr 2005 20:13:02 GMT
Message-ID: <irz8e.14316$G8.571@text.news.blueyonder.co.uk>

"gaddoz" <mynickname_at_gmail.com> wrote in message news:4iz8e.792134$b5.35210670_at_news3.tin.it...
> Hi all,
> I'm getting ORA-01950 error, when I try to create a table with sys user in
> the tablespace users.
> The sys user have unlimited tablespace system privilege granted... so why
> sys can't use tablespace users?
>
> And another problem... if I create a tables with userOne, why sys can't
> grant any privilege to UserTwo?
> Only the owner of the table can grant privilege to other user? There is no
> way?
> Can I change the owner of a table?
>
> Excuse me.. but I'm getting crazy trying to administer tablespace and
> schemas...
> Thank you!
>
> Gaddoz
>
>

no version and no example = no help Received on Sun Apr 17 2005 - 15:13:02 CDT