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 underlay
On 24 November 2010 08:57, Düster Horst wrote:
> 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 me
//www.agi.so.ch
-Ursprüngliche Nachricht-
Von: Szymon Guz [mailto:mabew...@gmail.com]
Gesendet am: Mittwoch, 24. November 2010 09:17
An: Düster Horst
Cc: pgsql-admin
Betreff: Re: [ADMIN] Deny access materialzsed view
On 24 November 2010 08:57, Düster Horst < horst.dues...@
On 24 November 2010 14:56, Düster Horst wrote:
> Hi Szymon Guz
>
> Thanks a lot for your response. I think the SECURITY DEFINER doesn't solve
> my problem. Here an example (stupid I know but just for explanation):
>
> 1. I have created the view myView (select id from myTable) with an insert
> r
h, 24. November 2010 15:26
An: Düster Horst
Cc: pgsql-admin
Betreff: Re: Re: [ADMIN] Deny access materialzsed view
On 24 November 2010 14:56, Düster Horst < horst.dues...@bd.so.ch>
wrote:
Hi Szymon Guz
Thanks a lot for your response. I think t