A few more questions:
Created table and view on table.
Granted insert,update, delete to table and select on view.
Problem:
User unable to delete from table when conditional (where); permission denied.
Only "delete from table" statement accepted which deletes the entire table.
Will an abstract rule such as "CREATE RULE newRule AS ON DELETE TO view DO
INSTEAD DELETE table" allow the user to define the conditions (where) for the
view delete?. Hard-coding conditions is not practical.
What are the permission issues for the view and table in a rule?
Comments and suggestions please.
Ray