Triggers after a rule

Hi list,

I am currently trying to give normal users some read access to some
tables in the database. I also need to give update access to one
column of one table.

I have the table contact, the user should not be able to read or
update anything in it, except for his own record. So I created the
view v_my_account. When the user selects * from it he only sees his
own record. That works great. I also made a rule:
CREATE RULE update_v_my_account AS ON UPDATE TO v_my_account
DO INSTEAD
UPDATE contact set pause=NEW.pause where username=USER;

This does not work since there are some triggers on the contact table
and the trigger function selects the contact table and I don't want to
give the user access to that.

I thought that when a rule is applied the triggers which are triggerd
would also have the same userid as the rule query, but I was wrong.

Does anyone know a nice workaround?

Wijnand
(I hope I was clear enough)