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.