Re: no rights

Yes, unless the owner of the object granted system select privilege using the with admin option it is not possible for system to grant to others. This even applies to users with dba privilege. You need to connect as the owner of the table.

Hth,

Sybrand Bakker, Oracle DBA

Leif Kuschel <Leif.Kuschel_at_t-online.de> wrote in message news:88bfdn$10klm$1_at_fu-berlin.de...
> Hello all,
>
> Is it possible that the user "system" has no rights to change
> objectprivilegs of another user ?
>
> I used the command
>
> GRANT SELECT ON "TABLESPACE1"."TABLE1" TO "U1";
>
> in Oracle SQL*Plus but it doesn't work.
>
> thanks, Leif
>
>
Received on Tue Feb 15 2000 - 00:00:00 CST