Re: no rights

From: Brian W. Chester <bwchester_at_home.com>
Date: 2000/02/15
Message-ID: <Fqeq4.6564$a27.176709@news1.rdc1.mb.home.com>#1/1

Leif,

You do not grant rights on the "tablespace".table. You grant rights on the schema.table as GRANT select ON system.xy TO u1.

HTH Brian

"Leif Kuschel" <Leif.Kuschel_at_t-online.de> wrote in message news:88bnb4$10tm8$1_at_fu-berlin.de...
> Hello Sybrand,
>
> thanks for the answer. I tried the following:
>
> I logged me into "Oracle Scheme Manager" as system
> next I created a table test in tablespace xy
>
> (now I should be the owner of test)
>
> after that, I tried to give the object privilege with:
>
> GRANT SELECT ON "xy"."test" to "u1";
>
> oracle means I have no rights for it.
>
> Sorry, I doesn't understand.
>
> thanks, Leif
>
>
>
Received on Tue Feb 15 2000 - 00:00:00 CST