Hi everyone,

Do I have to grant SELECT permission on a table T in order to allow
the user to execute:

DELETE FROM T WHERE ID=5

I can wipe the table (DELETE FROM T), but if I try to reference any
fields, FB complains (see below)... BTW, user sees the data through a
view, but the view references several tables and thus isn't
updateable.

Thanks in advance.

SQL log:

Database: somedb, User: peter, Role: ROLE_USER
SQL>
SQL>
SQL> show table t;
ID INTEGER Not Null
CONSTRAINT PK_T:
Primary key (ID)
SQL>
SQL> show grants t;
GRANT DELETE, REFERENCES ON T TO USER PETER
SQL>
SQL> delete from t where id = 2;
Statement failed, SQLCODE = -551

no permission for read/select access to TABLE T
SQL> delete from t;
SQL> rollback;