Re: grant update with grant option

I actually tested this up in database and the result is with admin option when the grantor revokes privilege, dependent grants are not revoked but
with grant option it is. when the grantor revokes privlege, it revokes all the dependent granted privilege.
So the reference manual is correct or this is a bug in Oracle ?

In article <943556105.5514.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 25 1999 - 19:03:13 CST