but helen, he says he gets an error - when you say it doesn't work correclty
it doesn't come back as an error. It's just silent (and wrong) so something
else is at play here
Alan

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, 23 January 2003 7:12 PM
To: ib-support@yahoogroups.com
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/