Subject | PROBLEMS WITH GRANT & REVOKE |
---|---|
Author | robjimwilliams |
Post date | 2002-09-05T17:13:18Z |
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.
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.