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.