Hi
I created a
materialized view to manage editings via a real postgres view. The view has some
rules to deliver all inserts, updates and deletes to the underlaying table with
the appropriate privileges, insert, update and delete, for members of an
editing role. To avoid editings on the underlaying table I want to deny any
access except select access to the table for all users. Does anyone
outside has an idea how to manage the described situation?
I'll appreciate any
hint.
Regards
Horst
------------------------------------------------ Dr. Horst Düster Kanton Solothurn Telefon ++41(0)32 627 25 32 mailto:horst.duester@xxxxxxxx
|