Postgres Pro
Downloads
Home   >   mailing lists

Re: Ver 15.X and restriction for schema=public - Mailing list pgsql-general

From David G. Johnston
Subject Re: Ver 15.X and restriction for schema=public
Date
Msg-id CAKFQuwbFOLniHKiv-OKCrT5yCEbSuXS-8mez2JeMzYTWsbq8sQ@mail.gmail.com
Whole thread Raw
In response to Ver 15.X and restriction for schema=public  (Bharani SV-forum <esteembsv-forum@yahoo.com>)
List pgsql-general
Tree view
On Monday, December 23, 2024, Bharani SV-forum <esteembsv-forum@yahoo.com> wrote:

I am in the process of upgrading EC2-PGS ver 13.X to 15.X 
I am aware  since ver 14.X, we have restriction in the usage of schema=public and the DBA need to grant exclusive priv for the tagged db user's.

Any suggestions or best practise

The only change at that point was removing some overly permissive defaults.  You don’t need to move objects, just reinstate explicitly those permissions that are needed that are no longer being granted by default.

You really cannot avoid the testing for a major version upgrade though.  Just expect error messages and be prepared to deal with them.

David J.

pgsql-general by date:

Previous
From: Bharani SV-forum
Date:
Subject: Ver 15.X and restriction for schema=public
Next
From: Adrian Klaver
Date:
Subject: Re: Ver 15.X and restriction for schema=public