public inbox for [email protected]  

help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: Bharani SV-forum <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Ver 15.X and restriction for schema=public
Date: Mon, 23 Dec 2024 12:58:27 -0700
Message-ID: <CAKFQuwbFOLniHKiv-OKCrT5yCEbSuXS-8mez2JeMzYTWsbq8sQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<CANzqJaC1Uk4H=55vV_jbFYMuD1f9Bb_4Y9WKvkZA3bt92bEUnw@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On Monday, December 23, 2024, Bharani SV-forum <[email protected]>
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.


view thread (61+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Ver 15.X and restriction for schema=public
  In-Reply-To: <CAKFQuwbFOLniHKiv-OKCrT5yCEbSuXS-8mez2JeMzYTWsbq8sQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox