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 1v1pQX-00D3v4-CW for pgsql-admin@arkaria.postgresql.org; Thu, 25 Sep 2025 17:06:41 +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 1v1pQV-0043iE-Qn for pgsql-admin@arkaria.postgresql.org; Thu, 25 Sep 2025 17:06:39 +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 1v1pQV-0043i5-Cu for pgsql-admin@lists.postgresql.org; Thu, 25 Sep 2025 17:06:39 +0000 Received: from mx0b-0039f802.pphosted.com ([205.220.176.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v1pQR-0003e3-0k for pgsql-admin@lists.postgresql.org; Thu, 25 Sep 2025 17:06:37 +0000 Received: from pps.filterd (m0209982.ppops.net [127.0.0.1]) by mx0b-0039f802.pphosted.com (8.18.1.11/8.18.1.11) with ESMTP id 58PEFq6H1812353 for ; Thu, 25 Sep 2025 10:06:32 -0700 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dat.com; h=cc :content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to; s=ppdk230404; bh=i1q1AK7dE0BKvHD600C9Ds2 Otlui7HcgWE77+s/sdSg=; b=Hy7sVQ+tj4sBNrOpBzkjRus6yoMDhZi90exKex+ RKl+ZuT+S/ltNLpPnJoC/hEI1nAm52kBCg/U+Mw1vvw8q74cA8WhaKMh5/BAYfID 22Y4wLBtp4y6XN0M3Jx0+4/GQZpAzdT61cfrpxkflnK4OkdcUBRNKDQWubPPb0li NX354Tk3G9fRM83kgEGpZVuHQh53g+8UmkaFFH25JKOcobzk0kB9nv3nGIivuz3S z2+0Ty8jveTCoDYAiuISjfSJEDB7qm3PV1JPgvQS7x7ZU5bgipUdRvK+jLPmyZH8 Zow1Mkuv/z3QfChYnMMRbBVf2kXWa1Gi+4njM+XyuWc2m0w== Received: from mail-ej1-f69.google.com (mail-ej1-f69.google.com [209.85.218.69]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 499td1qjrs-1 (version=TLSv1.3 cipher=TLS_AES_128_GCM_SHA256 bits=128 verify=NOT) for ; Thu, 25 Sep 2025 10:06:32 -0700 (PDT) Received: by mail-ej1-f69.google.com with SMTP id a640c23a62f3a-afcb7338319so111118666b.0 for ; Thu, 25 Sep 2025 10:06:32 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758819991; x=1759424791; 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=i1q1AK7dE0BKvHD600C9Ds2Otlui7HcgWE77+s/sdSg=; b=w/ToOTRMXSa8/+q5jbUQITBEhvAiRplQU2McpnjF4DvuKonfACzx2WKy8FhX7+/CTm EvkdtjzuXuOXzK5cFihQ8I+ZM5zboxjZhMyACg1KrXS6vV4pleS4rCyCQyplbrHtHhC5 UU/GuabCdnoZFHnhFo+y3b6/7as1P6uAC9d/jv1muJIK369dnl/zA8PR6hGsvzYzc+6D ABIvW+wdK4sajU4kRJrZsRl+IjXIInRnUBDlgmpkQ/puWLzXZbYscF+pVw6aryYiy8lM fvQ1gUf4RZ9FCt4YKtTlaAyTVmJloPi4WWucHgRoehHiYRW+apx6ahiCsSCVQt1JlZjH UFnw== X-Gm-Message-State: AOJu0YwnVmvayVKxmg/iK6shjadMebZ9MHSXdP7l23Ajpc/Q962gqLrg v+SJh0EsSc4uAZO+mAeBtMQA4UZnHrXGhO2SDZZNP2tuDiivRy7fP6069T02Tv8IghsSqTb6zEH /v5akRdTob3G8e918Woy+DRWQTeDIVx3bjD5mg58ykLaIvdVzqw+z8w7LSjVtEQIph7u4qvsdWT VH7I6GMtEs2CmD/olMSqHBHyb0rpiH3eCCoEMiQyPY0eLLEPIa06WdOXig5nKs0NqLUv298bE= X-Gm-Gg: ASbGncslUBb8PKExIoRTL7I/z2vp20oPqEuEO3rX4FtruzG1IoJR8Qba8fskAYvQXVu /lf9o74M6eDFYhjdZDan+NmgZ0wS8bAKLX+S3LDJyJRlPCKA/dA0B49WeCxKaTXYoXOhZaYjSwE 4yJtOWHT1p3VU3Hy54OaA= X-Received: by 2002:a17:907:7282:b0:b29:e717:f0ab with SMTP id a640c23a62f3a-b34be4e4f76mr424691366b.32.1758819990850; Thu, 25 Sep 2025 10:06:30 -0700 (PDT) X-Google-Smtp-Source: AGHT+IFXjVOf1VKCp3rfkkmtFmu54Q3KN8ujc5LqM/bA2IEA34+98dzRjKP5l3QXCeez5WkjlhercZwSX7Ydwick3xo= X-Received: by 2002:a17:907:7282:b0:b29:e717:f0ab with SMTP id a640c23a62f3a-b34be4e4f76mr424688166b.32.1758819990389; Thu, 25 Sep 2025 10:06:30 -0700 (PDT) MIME-Version: 1.0 References: <3772273.1758819489@sss.pgh.pa.us> In-Reply-To: <3772273.1758819489@sss.pgh.pa.us> From: Sam Stearns Date: Thu, 25 Sep 2025 10:06:18 -0700 X-Gm-Features: AS18NWD9KNfhMCtymVKpiS0uf81D267Qnsbha0kdwKk8duiDePqlKt8P_xH0A1M Message-ID: Subject: Re: INSERT Permission Denied To: Tom Lane Cc: Pgsql-admin , Dugan Kniesteadt , Henry Ashu , Avi Vallarapu Content-Type: multipart/alternative; boundary="000000000000c059db063fa3307a" X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1117,Hydra:6.1.9,FMLib:17.12.80.40 definitions=2025-09-25_01,2025-09-25_01,2025-03-28_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c059db063fa3307a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable USAGE has already been granted. On Thu, Sep 25, 2025 at 9:58=E2=80=AFAM Tom Lane wrote: > Sam Stearns writes: > I have an INSERT: > that's > failing with permission denied on the schema: > ERROR: permission denied > for schema treg > LINE 1: SELECT 1 FROM ONLY "treg". "cd_combined_offices= " > x WHERE > ZjQcmQRYFpfptBannerStart > This Message Is From an External Sender > This message came from outside your organization. > > ZjQcmQRYFpfptBannerEnd > > Sam Stearns writes: > > I have an INSERT: > > that's failing with permission denied on the schema: > > ERROR: permission denied for schema treg > > LINE 1: SELECT 1 FROM ONLY "treg"."cd_combined_offices" x WHERE "com... > > ^ > > You need to grant USAGE permission on that schema. It's roughly > comparable to search privilege on a directory in most OSes. > > regards, tom lane > > --=20 Samuel Stearns Team Lead - Database c: 971 762 6879 | o: 971 762 6879 | DAT.com --000000000000c059db063fa3307a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
USAGE has already been granted.

On Th= u, Sep 25, 2025 at 9:58=E2=80=AFAM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Sam Stearns <sam.=E2=80=8Astearns@=E2=80=8Adat.=E2=80=8Acom> writes: = > I have an INSERT: > that's failing with permission denied on th= e schema: > ERROR: permission denied for schema treg > LINE 1: SELECT= 1 FROM ONLY "treg".=E2=80=8A"cd_combined_offices" x WH= ERE
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.
=C2=A0
ZjQcmQRYFpfptBannerEnd
Sam Stearns <sam.stearns@dat.com> writes:
> I have an INSERT:
> that's failing with permission denied on the schema:
> ERROR:  permission denied for schema treg
> LINE 1: SELECT 1 FROM ONLY "treg"."cd_combined_offices&=
quot; x WHERE "com...
>                            ^

You need to grant USAGE permission on that schema.  It's roughly
comparable to search privilege on a directory in most OSes.

			regards, tom lane


--

Samuel Stearns
Team Lead - Databas= e
c: 971 76= 2 6879 = | o: 97= 1 762 6879 | D= AT.com


--000000000000c059db063fa3307a--