At 09:49 AM 23/01/2003 +0200, you wrote:

>Hi,
>
>I think you didn't understant my problem.
>Revoke is not about drop/delete table.
>And table names can't be case sensitive in interbase.
>
>I must revoke rights from user.

I think this was just a mistake. Aage meant "what is the name of the table
you want to operate on?"

In InterBase 6 and higher, table names are case-sensitive if they are
defined with double-quoted identifiers. So, if your table was defined with

create table "Table1" (
....)

Then you will need to do
REVOKE SELECT ON "Table1" FROM JOHN

Also, this will not be valid unless you previously GRANTed SELECT
explicitly to JOHN. If you did GRANT ALL TO JOHN or GRANT <whatever> TO
PUBLIC, then REVOKE <specific privilege> FROM <specific users> won't
work. These issues are why you really need to plan your user privileges
carefully. I chart privileges and roles using a Visio Orgchart and/or a
Venn diagram...

heLen