small question

From: "Roman Havrylyak" <roma(at)ukr(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: small question
Date: 2001-08-17 12:27:43
Message-ID: 9liuui$2gfo$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 GRANT permission on both tables - 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, how to
do this?

Browse pgsql-general by date

  From Date Subject
Next Message Roman Havrylyak 2001-08-17 12:29:47 rotating table question
Previous Message Feite Brekeveld 2001-08-17 12:18:25 Re: slow update but have an index