permissions question - Mailing list pgsql-general

From Roman Havrylyak
Subject permissions question
Date
Msg-id 9lj4gk$2he4$1@news.tht.net
Whole thread Raw
Responses Re: permissions question  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 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?






pgsql-general by date:

Previous
From: "Michael Ansley (UK)"
Date:
Subject: RE: Roll Back dont roll back counters
Next
From: Tom Lane
Date:
Subject: Re: Max number of tables in a db?