Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: grant update with grant option
<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 ?
Yes, you are right.
The object privileges have cascading effect to revoke privilege.
The system privileges do not.
IMO, you can burn Couchman's book, the book has plenty of bugs. Received on Fri Nov 26 1999 - 09:24:24 CST