Re: no rights

Because you must
grant select on test to u1 or
grant select on system.test to u1
See the differences
owner.table
not tablespace_name.table.

Günter

Leif Kuschel schrieb:

> 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

--
---------------------------------------------------------------
Dipl.-Inform.  Günter Huerkamp

Web        : http://gh.notrix.de

Email
privat     : mailto:guenter-huerkamp_at_t-online.de
privat     : mailto:guenter-huerkamp_at_web.de
dienstlich : mailto:guenter.huerkamp_at_lk-wl.nrw.de


---------------------------------------------------------------