Suppose we have table A and table B. When action is performed on table A (for example INSERT), some action (for example UPDATE) through the trigger is done on table B. If user had permission on both tables (GRANT INSERT on table A and GRANT UPDATE on table B)- everything is good. But in that way user can get access to table B directly. If I need to limit user's access to table B only through the trigger from table A, how to do this? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
