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

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, January 23, 2003 10:12 AM
Subject: Re: [ib-support] Re: REVOKE


> 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
>
>
>
> 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/