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.
>
> Set
>
> At 14:20 23.01.2003 +0200, you wrote:
> >There is a problem but i can't understand what is the problem.
> >My table names are uppercase.
> >And Revoke command is right.
> >I have read revoke command from documents.
> >I must solve this problem.
> >
> >REVOKE SELECT ON TABLE1 FROM JOHN
>
>
> 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/
>
>
>