Only, it's too bad that you can't update the records from the "view data" dialog. It works in access2000, it doesn't know the difference between views and tables (the difference is actually very small). You probably get some annoying error when you try to edit a normal select view from access, though.
I guess pg_admin assumes that views cannot be edited, which is incorrect in this case. Maybe this is something that could be enhanced in a future release?
oh, i see i forgot: revoke all on view_firm1 from amy; revoke all on view_firm1 from firm2; revoke all on view_firm2 from john; revoke all on view_firm2 from firm1;
Cheers, WBL
-- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw