Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tPoZa-00FVhS-Nn for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 19:58:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tPoZX-00FLVP-TG for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 19:58:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tPoZX-00FLRE-Ho for pgsql-general@lists.postgresql.org; Mon, 23 Dec 2024 19:58:35 +0000 Received: from mail-oi1-x22c.google.com ([2607:f8b0:4864:20::22c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tPoZU-001H1r-Fg for pgsql-general@postgresql.org; Mon, 23 Dec 2024 19:58:34 +0000 Received: by mail-oi1-x22c.google.com with SMTP id 5614622812f47-3eb9ba53f90so1193062b6e.1 for ; Mon, 23 Dec 2024 11:58:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734983910; x=1735588710; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=WtEwC0uhww831OWOrlegXiY3TsKY+n+dbwORW0ALb5Y=; b=EG2R3R5uk/qFwer/VZmbeQJoBVmsIPry/ZrgrVj4NQ0w1Y5DYbBbTjwwEbcx1YSdmg csUD69t7TNNVQuwXSrAg7G/2OfuHIB2QpqyU1IFBhDBYvzVOEzhVw0r411WD6QpiUCln ruhlZYrZD9wOZBuNhBs7psvtZ2FNLclxvMYfptJeF67mFjzwQilcFK90Qihm/6XDmFf7 VDHHAjt+l3Fh2Nya2Z0q7tw4DI2rOgCBqcAqR6Ql6+XrCG+cVPQbiSAk7xMN0M7uXbld HdO+grDzIgLJYloRXaSNNSqZEbiAmmmRCi5Zp1vJjrkzfTVcqzXB6r9niJ4qP51j6Ly3 BUpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734983910; x=1735588710; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=WtEwC0uhww831OWOrlegXiY3TsKY+n+dbwORW0ALb5Y=; b=ZdhPA2xAjUW55ynX5+niXcEVPYwHL0j9Dnl1y67OsMGBzdqS4Ulq0lcEvr7/gRaTTE a7+0+nIHVDIYR7PtAublg29rdVfZNF5Wh+2z1p9Yr0XEROp80KafQUgEEG/a9DM8+Hf0 yUdkVq+h75Io/+3DpOjdECtekkbcY7FvgCOK7hncdpFN2HSO6D///t0A7Q2v06I4Bk5Q Vv/2tl6WQsg/Hy0gdG5enwsXyngIfhzDLP2Tuznp3dC2h0hclgumodIHYfHyFTSGualc 5FWgUJTGbdy+1TXztZLUJl0wx24CM7GhxWD/JLwMWKddZyskkpAWFl54UA1teH+07nSa otRg== X-Gm-Message-State: AOJu0Yzx4ulpZpnFk818Kcj7iif6vWUoGtgqtWp2JAgN6DE66EFF0Us5 0fbjUoGVJynCK6reJP53itn+e83TSoDcyeHhhUCbcrqjyere7JJbcATkkG0EUneujdw8ODQYNVP 7FRwZ1dBKa9RrMmIMjGzw3n/yYSk= X-Gm-Gg: ASbGncsU5iy/try1Ne84aUPTYpebtJT3DEdulQBx2YRZ2NVJMypJuQJdRjOoCxlJ/8X x03/7V2F+PY5ni1KYY9Tu9jhlqP5Q2zzguptL6w== X-Google-Smtp-Source: AGHT+IHTr29amww0nHd/fbzy4hzv9L610tOtVfj8cO8FgScM30IS/BYLO1mjkmBkyCcLKY3rJ0TvZ05WSSeirolh3PM= X-Received: by 2002:a05:6808:2388:b0:3e7:6191:91e4 with SMTP id 5614622812f47-3ed88f623d8mr7045250b6e.24.1734983908671; Mon, 23 Dec 2024 11:58:28 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a8a:29a:0:b0:577:9519:f64a with HTTP; Mon, 23 Dec 2024 11:58:27 -0800 (PST) In-Reply-To: <1694853482.6517504.1734981981968@mail.yahoo.com> References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com> <498dfb34-4dd7-4f48-8188-355e1488d7e6@aklaver.com> <1061066336.5835157.1733316137292@mail.yahoo.com> <1918413683.2239751.1733944364448@mail.yahoo.com> <037a8338-3434-47d4-aaad-ef186d4d3250@aklaver.com> <101139100.4053671.1734383960480@mail.yahoo.com> <1875422740.4095620.1734388259706@mail.yahoo.com> <1528119631.4096246.1734390318281@mail.yahoo.com> <2033286177.1733661.1734651404850@mail.yahoo.com> <8833d8c7-3713-4d6f-9eab-35270e769564@aklaver.com> <1392047062.5689697.1734710997053@mail.yahoo.com> <783439164.5695290.1734713539262@mail.yahoo.com> <928427177.4710979.1734722745840@mail.yahoo.com> <2036867199.5856152.1734735063013@mail.yahoo.com> <1694853482.6517504.1734981981968@mail.yahoo.com> From: "David G. Johnston" Date: Mon, 23 Dec 2024 12:58:27 -0700 Message-ID: Subject: Re: Ver 15.X and restriction for schema=public To: Bharani SV-forum Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000914ab10629f56b57" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000914ab10629f56b57 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=3Dpublic and the DBA need to grant exclusive priv for the tagged d= b > user's. > > Any suggestions or best practise > The only change at that point was removing some overly permissive defaults. You don=E2=80=99t need to move objects, just reinstate explicitl= y 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. --000000000000914ab10629f56b57 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=C2=A0
I am aware= =C2=A0 since ver 14.X, we have restriction in the usage of schema=3Dpublic = and the DBA need to grant exclusive priv for the tagged db user's.

Any suggestions or best practi= se

The only change at that = point was removing some overly permissive defaults.=C2=A0 You don=E2=80=99t= 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.= =C2=A0 Just expect error messages and be prepared to deal with them.
<= div>
David J.
--000000000000914ab10629f56b57--