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