I did backup and restore the database.
And tried again.
But there isn't any difference.

I am using Interbase 6.2
Ib is running Local server.

I tried this at another server with another databases (Windows 2000 Server)
But revoke is not working.

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, January 23, 2003 3:54 PM
Subject: Re: [ib-support] Re: REVOKE


> Is his/her name actually JOHN and the table name TABLE1? I'm used to work
> places where initials are used as user names. But my initials (and what
I'm
> called amongst foreigners) are SET and that causes all sorts of trouble if
> you try using it as a user name. And I wouldn't be all too surprised if
one
> db engine allowed GRANT SELECT ON TABLE1 TO SET, whereas REVOKE SELECT ON
> TABLE1 FROM SET would fail.
>
> Just a shot in the dark. If there's nothing strange about the user or
table
> name, try doing a backup and restore it (to a different location) and see
> if that helps. Failing that, it would be nice to know what database you're
> using (e.g. it could be an unknown or solved bug in Fb 1.5)
>
> Set
>
> At 15:06 23.01.2003 +0200, you wrote:
> >Yes my sql statements are the same.
> >and you are right.
> >something strange is going on.
> >----- Original Message -----
> >From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>
> >To: <ib-support@yahoogroups.com>
> >Sent: Thursday, January 23, 2003 3:19 PM
> >Subject: Re: [ib-support] Re: REVOKE
> >
> >
> > > Try
> > >
> > > GRANT SELECT ON TABLE1 TO JOHN
> > >
> > > and then commit. If that works and you afterwards unsuccessfully
> > >
> > > REVOKE SELECT ON TABLE1 FROM JOHN
> > >
> > > then something strange is going on.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>