Re: Baffled by basic permission issue. - Mailing list pgsql-admin

From Wim Bertels
Subject Re: Baffled by basic permission issue.
Date
Msg-id efa9c36e5050bca1cde2e57b9b2c10f1a7535d36.camel@ucll.be
Whole thread Raw
In response to Re: Baffled by basic permission issue.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom Lane schreef op wo 16-06-2021 om 17:21 [-0400]:
> 
> When you select from a view, you need permissions only on the view.
> The view's owner needs permissions on the underlying table(s).
> This is so that views can act as permission gateways.

additionally,
if you want to allow modifications through this view,
have a look at 'with check option' to avoid unwanted permission side-
effects

> 
>             regards, tom lane
> 
> 
-- 
mvg,
Wim Bertels







pgsql-admin by date:

Previous
From: Ni Ne
Date:
Subject: Assistance setting up LDAPS authentication for pgadmin4
Next
From: kaido vaikla
Date:
Subject: Re: How does vacuum full works if table is partitioned?