Subject PROBLEMS WITH GRANT & REVOKE
Author robjimwilliams
I'm new to client server and Interbase.

I'm having problems with grant and revoke running IB6. What I want
to do is grant a user SELECT, INSERT and UPDATE but not DELETE. I've
tried the following:

GRANT
SELECT,
INSERT,
UPDATE
ON CUSTS TO ROBERT;

ALSO

GRANT
ALL
ON CUSTS TO ROBERT;

and then did

REVOKE
DELETE
ON CUSTS TO ROBERT;

Either way I get the same result. The interface (written in Delphi)
behaves as if I had also REVOKEd INSERT and UPDATE, although when you
look at the permissions on the table INSERT AND UPDATE are both
selected - WHAT am I doing wrong??

Thanks.