Re: grant update with grant option

You have done the right thing by testing for yourself. You will find numerous instances in the Couchman book where this is a good idea.

Van

<yewpc_at_rnd.celcom.com.my> wrote in message news:81km8g$ehr$1_at_nnrp1.deja.com...
> 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 Fri Nov 26 1999 - 14:11:47 CST