Re: Restricting user to see schema structure - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Restricting user to see schema structure
Date
Msg-id b2d5056c-399e-9d37-dd91-319a2094565a@aklaver.com
Whole thread Raw
In response to Re: Restricting user to see schema structure  (Bryn Llewellyn <bryn@yugabyte.com>)
Responses Re: Restricting user to see schema structure
List pgsql-general
On 5/17/22 13:21, Bryn Llewellyn wrote:

> 
> The paragraph describes very surprising behavior in the present era of 
> "secure by default". The sentence "For maximum security..." at the end 
> emphasizes this and has you go to some effort (CREATE and REVOKE in the 
> same txn) to undo the "insecurity by default" paradigm. I s'pose that 
> compatibility on upgrade means that nothing can change here.

There is movement on this front coming in Postgres 15:

https://www.postgresql.org/docs/devel/release-15.html#id-1.11.6.5.3


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Restricting user to see schema structure
Next
From: Bryn Llewellyn
Date:
Subject: Re: Restricting user to see schema structure