Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: grant update with grant option
with grant option gives the grantee the right to pass the grant on.
Relationships are NOT maintained.
Whenever the orginal grantor revokes privilege, dependent grants are NOT
revoked.
For me this is one of the reason NEVER to use with grant option.
Hth
--
Sybrand Bakker, Oracle DBA
<yewpc_at_rnd.celcom.com.my> wrote in message
news:81imvm$4a6$1_at_nnrp1.deja.com...
> Question,
> From the reference manual of OCP7 by Couchman.
> "The granting privileges with admin option or grant option has no
> cascading effect to revoke privilege" this is not right right ?
> It is only true for grant with admin option but not with grant option.
> Can anyone tell me whether i am right ?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 25 1999 - 12:53:49 CST