Re: Ver 15.X and restriction for schema=public

2024-12-23 Thread Adrian Klaver
On 12/23/24 12:17 PM, Bharani SV-forum wrote: Adrian TQ. Exactly , you have provided the needed information For existing databases, especially those having multiple users, - I will consider revoking CREATE permission on the public schema to adopt this new default. You may want to do some t

Re: Ver 15.X and restriction for schema=public

2024-12-23 Thread Adrian Klaver
On 12/23/24 11:26 AM, Bharani SV-forum wrote: Team 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. Are you referring to this?: https:/

Re: Ver 15.X and restriction for schema=public

2024-12-23 Thread David G. Johnston
On Monday, December 23, 2024, Bharani SV-forum 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 pr

Ver 15.X and restriction for schema=public

2024-12-23 Thread Bharani SV-forum
TeamI 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. Assume i want to enforce it,Can i retag all the object tables/indexex/packages/procedure