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 1uJv27-009I4s-PI for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 14:11:59 +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 1uJv26-008PNQ-9P for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 14:11:58 +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 1uJv25-008PNI-UN for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 14:11:58 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uJv23-000NYY-1U for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 14:11:57 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-6065803ef35so693110eaf.1 for ; Tue, 27 May 2025 07:11:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748355114; x=1748959914; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=cVbSzse3jycLHjIc/B5O6Iwfg0jWFmHhgT5l/m7bugo=; b=jTfNkEggDUsNCl740BaxFnQFRHivzb9Pr70rouYqjlSyXEL9ygUda0nXXrM74PQM8L S4OPWVuKtVlvUStle113cgwnH103rnOwSc35XS8oXbZmp6TnKWCrBM/BrKOrc8xQK8hD sGJOH4nmPow0FurZE0ipE63ytxLVZlJMFRkKWZIR7UXOQv2zVZD+oC3LN/IQ6xMuBCir jR9WO9liUBrOo6QwuC8SfYAj3ytFRoXVLJCpQhmAaQT0B7YUbWjdNpQz+4ILSgLpg+XJ k+Uh2uKXc2AtzRbBq/qhohuFfqCZet0uslwIbRy3sYnF33LE39u87+LJTqXLuVTfTHqi MTAQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748355114; x=1748959914; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=cVbSzse3jycLHjIc/B5O6Iwfg0jWFmHhgT5l/m7bugo=; b=a+bKifLr4u+pJF2/UP71tXclSsJ+r9c/+P9FO7Bqa7pJjK71ZN6xhRqu8x8BCxMhka YU9nWw4fuwDZn3S9ontA3c0rWko+k+roNMvbIuZWDDqgpLNSvhRYlKQLDys4dKgHMTPK q5C7lrx22r/FIjLw939cN4qyWAtXZaYLmyeyAgWxmhfSs5G55RsqPWNMI5+0j0lREFol Q8zTD0IPI8bwTmZlLFWsx+H1hOGK7ANsykSiBFbCM4jGLIkqf4Icb+0zN5oK7yPBxjEQ kgN/N7XVSzqXSxzm9OrhijZK15tW8a+RVYDYlXINIhtX/i+/AF4OnwMFYgMypj9bqrpZ +XUA== X-Gm-Message-State: AOJu0Yz+fpY9HUbCeMMf0chIVeAwjU00yEkbVKlSTuxnIHfmNTbxr3xs YkiCftJ21+eIviInb11wPG0TwQCyxQBl9aU4Q8LJNCM3whkXmyvDJq3kSoBi4odggnOHGORd97d KKGYjR9NPSiCF1szN1H4UhEDQAetOWw0= X-Gm-Gg: ASbGnct1o0Ke9Tahb1iuIlH8XHYsznBZBIaf6tm4NT784FXtP1lzj8T8wEdcMNOg8Ub mY7rqeTykYGeI1W81XJDOuLTwti5bVnCJcEwXGZRCZv6fteT7ZhU4PRbaDdSI8DNCehoI2tdu2D 8ugwrodYKCkghz4H/anAQCz0/8jvt5s9eErbkZRmes9h5SiAvWEooCN4yf6w1P4sx/ X-Google-Smtp-Source: AGHT+IFWJA9bEWSLLUD6olZJWumjLOFcH1XzAnb9WIHrfE4KRxqe+1ugooXgtOneVLKEo+RhlwxDW8ZrB/V4AyFA25U= X-Received: by 2002:a4a:e90f:0:b0:60b:9d55:966 with SMTP id 006d021491bc7-60b9fc04988mr5905424eaf.8.1748355113790; Tue, 27 May 2025 07:11:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Tue, 27 May 2025 07:11:16 -0700 X-Gm-Features: AX0GCFtm8M8K3nmhaXAe44_B6Y0vUEh1nP7kNBRvLPOUwDd6ayFxo1rxpDTkNMo Message-ID: Subject: Re: Tables in public schema To: Edwin UY Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000007fb1b006361ea579" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007fb1b006361ea579 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, May 27, 2025 at 7:02=E2=80=AFAM Edwin UY wrote= : > Will I have to redo the grants? > If you use "alter table set schema" the table OID will not change and the grants should follow it. Users would be subject to whatever new permissions apply to the newly created schema rather than the public schema though. David J. --0000000000007fb1b006361ea579 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, May 27, 2025 at 7:02=E2=80=AFAM Edwin UY <edwin.uy@gmail.com> wrote:
Wi= ll I have to redo the grants?

=
If you use "alter table set schema" the table OID will not cha= nge and the grants should=C2=A0follow it.=C2=A0 Users would be subject to w= hatever new permissions apply to the newly created schema rather than the p= ublic schema though.

David J.

--0000000000007fb1b006361ea579--