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 1v1pZH-00D5CN-3j for pgsql-admin@arkaria.postgresql.org; Thu, 25 Sep 2025 17:15:43 +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 1v1pZF-004BVQ-Ov for pgsql-admin@arkaria.postgresql.org; Thu, 25 Sep 2025 17:15:41 +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 1v1pZF-004BVI-Be for pgsql-admin@lists.postgresql.org; Thu, 25 Sep 2025 17:15:41 +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 1v1pZB-0003ip-1R for pgsql-admin@lists.postgresql.org; Thu, 25 Sep 2025 17:15:40 +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 58PECubL1753777 for ; Thu, 25 Sep 2025 10:15:34 -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=3aKJQcJrFFMQQWtoNS55TcD x62iw2NXT5TBJol4CiqY=; b=ZTgGqNJM6W6IyvvdLC//UIT0p3+905Th6T9BfKl vd4FGrSDG/HGvZ1VkZk+/0gvtk3ZrQC8h5WS62JV60/yBJ74Ima5anleO3RiwpJk WvZ4Muek2S68uo4zckiu+Sy38dFGuc8iG8X+aGQ4LuhjNdjozEw3o1uzxhgCiDMd 3HcymNVzNamFIB7vDyD+a3xlCk+0FsHoGPNt9ae7Iq6gfocIcQ5Fq92AWk4EYoGJ xddii2KMtdGaClTvTcJ0ACOZ/2CycmeA8NQ1J1Sgb+P1BruZByrkqCEaL700LdGP GgEpm/PnnHNnAEo4ENZBtzRx1Dm0EnZDqLMI6jHi7hWdDzA== 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 499td1qkn1-1 (version=TLSv1.3 cipher=TLS_AES_128_GCM_SHA256 bits=128 verify=NOT) for ; Thu, 25 Sep 2025 10:15:34 -0700 (PDT) Received: by mail-ej1-f69.google.com with SMTP id a640c23a62f3a-b33d785dc3bso125781066b.3 for ; Thu, 25 Sep 2025 10:15:34 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758820532; x=1759425332; 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=3aKJQcJrFFMQQWtoNS55TcDx62iw2NXT5TBJol4CiqY=; b=heYHDvh0r1xe/KDvyj5XLaHrQtMxIgY8dRl9uvZefGIfyP8AIVlA8KkUCF2ACUoMWx +MyNrsW1MoJGpXZE2xVrFu7rR+ejHxFIoCvr1imxrqnELjeeS1z2DpwgPHKnRHOJMOw3 eBQU6ZGnESbmjtXxZSDR+kPmlmKDuG8gI/XHAThrp5DFRD1epLt4p8SnKo2M3q83SamE CulQ4hB/FaJ7BtnprvCmlV0xG/PHw+5p9LgsDocmNP4e/ssCrv59DbhcwJ+WUoCoui9J rsZ7eyJyDZDd87Xy6LZnAJkcWjR6548zHQVM/vKL2ca5j3TK2s3KY4E3lKY5oxOeMEDj pZvA== X-Gm-Message-State: AOJu0YwUgwVgV6tYoXsEEruCiHHORAPfWFlGcR9m6ifmNo5OiST6U+67 b0RSR/E+BNFTbTYs5PKfpXeb4zIHQ/ac10Wen8IMkAShihNWmHfwYbl3KXFXYrEDTrvlu1ubbFn 22uTz0KhVyERt16cSeJHUtWUjw23gYIWUlfkZAJ3jf/QcEKSpnN2oGHQfkVpL6MCJ8rTgZZ74ZZ IQj669WXeIqv4IUB2DVrmz1frz8X5j8QzFHAFkrzyNAhYNdevg+FUpA2uD8VavGn0y6qPyN1HcD xl0avrGCQ== X-Gm-Gg: ASbGnct4ICOSCyCmS/bq9KJam6U3v5aSXlPvfeCxzY4oW/OG8mpdLcdnJ2iy949kMZZ oMu1xvA87ztDf8LZTcjGWG4YJtkO25GXCdZKdgyizV3z8B4N8JxRizGDUeqTwDaE3YNxRzlqfk6 GPKFJKtjb/wl8Ugx2vHpw= X-Received: by 2002:a17:907:1b17:b0:b04:9825:bd77 with SMTP id a640c23a62f3a-b34bbebbfeemr479804066b.55.1758820532067; Thu, 25 Sep 2025 10:15:32 -0700 (PDT) X-Google-Smtp-Source: AGHT+IGcYd+KCmZk8XnhT87kbO/hsxJWtJitDlN7N+sVOGF7FZfBa/UM0gl2Zdgd+EawP9LmOswwW0P3z7SwErK2p58= X-Received: by 2002:a17:907:1b17:b0:b04:9825:bd77 with SMTP id a640c23a62f3a-b34bbebbfeemr479801366b.55.1758820531647; Thu, 25 Sep 2025 10:15:31 -0700 (PDT) MIME-Version: 1.0 References: <3772273.1758819489@sss.pgh.pa.us> <3773384.1758820097@sss.pgh.pa.us> In-Reply-To: <3773384.1758820097@sss.pgh.pa.us> From: Sam Stearns Date: Thu, 25 Sep 2025 10:15:20 -0700 X-Gm-Features: AS18NWBIBpXVS5Uzu8mOeI7UGgz-_gbzp9RvkfVW8cpqW_SypnA5GFR0S1H09Vk Message-ID: Subject: Re: INSERT Permission Denied To: Tom Lane Cc: Pgsql-admin , Dugan Kniesteadt , Henry Ashu , Avi Vallarapu Content-Type: multipart/alternative; boundary="000000000000034f4d063fa351df" 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 --000000000000034f4d063fa351df Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable csbstage=3D# grant usage on schema treg to cwstagesvc; GRANT csbstage=3D# \q [postgres@shiludbapql01 scripts]$ psql -U cwstagesvc csbstage Password for user cwstagesvc: psql (16.9) Type "help" for help. csbstage=3D# begin; BEGIN csbstage=3D*# INSERT INTO treg.cd_combined_office_mappings ( csbstage(*# tcsi_office_id, combined_office_id, sb2_account_id, postal_code, category, csbstage(*# account_name, city, state, is_preferred, is_closed, is_parent csbstage(*# ) VALUES csbstage-*# ('TCSI001', 10001, 2001, '90210', 'RETAIL', 'Acme Corp', 'Los Angeles', 'CA', 'Y', 'N', 'Y'), csbstage-*# ('TCSI002', 10001, 2002, '10001', 'WHOLESALE', 'Beta LLC', 'New York', 'NY', 'N', 'N', 'N'), csbstage-*# ('TCSI003', 10002, 2003, '60601', 'RETAIL', 'Gamma Inc', 'Chicago', 'IL', 'Y', 'N', 'N'), csbstage-*# ('TCSI004', 10003, 2004, '77001', 'SERVICE', 'Delta Co', 'Houston', 'TX', 'N', 'Y', 'N'), csbstage-*# ('TCSI005', 10003, 2005, '33101', 'RETAIL', 'Epsilon Ltd', 'Miami', 'FL', 'Y', 'N', 'Y'); ERROR: permission denied for schema treg LINE 1: SELECT 1 FROM ONLY "treg"."cd_combined_offices" x WHERE "com... ^ QUERY: SELECT 1 FROM ONLY "treg"."cd_combined_offices" x WHERE "combined_office_id" OPERATOR(pg_catalog.=3D) $1 FOR KEY SHARE OF x csbstage=3D!# rollback; ROLLBACK csbstage=3D# On Thu, Sep 25, 2025 at 10:08=E2=80=AFAM Tom Lane wrote= : > Sam Stearns writes: > USAGE has already been > granted. [ shrug. . . ] Apparently not. regards, tom lane =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D > =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D = =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D > =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D = =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D > =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D = =E2=80=8D > ZjQcmQRYFpfptBannerStart > This Message Is From an External Sender > This message came from outside your organization. > > ZjQcmQRYFpfptBannerEnd > > Sam Stearns writes: > > USAGE has already been granted. > > [ shrug... ] Apparently not. > > regards, tom lane > > --=20 Samuel Stearns Team Lead - Database c: 971 762 6879 | o: 971 762 6879 | DAT.com --000000000000034f4d063fa351df Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
csbstage=3D# grant usage on schema treg to cwstagesvc;
= GRANT
csbstage=3D# \q
[postgres@shiludbapql01 scripts]$ psql -U cwsta= gesvc csbstage
Password for user cwstagesvc:
psql (16.9)
Type &quo= t;help" for help.

csbstage=3D# begin;
BEGIN
csbstage=3D*#= INSERT INTO treg.cd_combined_office_mappings (
csbstage(*# =C2=A0 =C2= =A0 tcsi_office_id, combined_office_id, sb2_account_id, postal_code, catego= ry,
csbstage(*# =C2=A0 =C2=A0 account_name, city, state, is_preferred, i= s_closed, is_parent
csbstage(*# ) VALUES
csbstage-*# ('TCSI001= 9;, 10001, 2001, '90210', 'RETAIL', 'Acme Corp', &#= 39;Los Angeles', 'CA', 'Y', 'N', 'Y'),<= br>csbstage-*# ('TCSI002', 10001, 2002, '10001', 'WHOLE= SALE', 'Beta LLC', 'New York', 'NY', 'N'= ;, 'N', 'N'),
csbstage-*# ('TCSI003', 10002, 200= 3, '60601', 'RETAIL', 'Gamma Inc', 'Chicago'= ;, 'IL', 'Y', 'N', 'N'),
csbstage-*# (&#= 39;TCSI004', 10003, 2004, '77001', 'SERVICE', 'Delt= a Co', 'Houston', 'TX', 'N', 'Y', '= N'),
csbstage-*# ('TCSI005', 10003, 2005, '33101', &= #39;RETAIL', 'Epsilon Ltd', 'Miami', 'FL', '= ;Y', 'N', 'Y');
ERROR: =C2=A0permission denied for s= chema treg
LINE 1: SELECT 1 FROM ONLY "treg"."cd_combined= _offices" x WHERE "com...
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^
QUERY: = =C2=A0SELECT 1 FROM ONLY "treg"."cd_combined_offices" x= WHERE "combined_office_id" OPERATOR(pg_catalog.=3D) $1 FOR KEY S= HARE OF x
csbstage=3D!# rollback;
ROLLBACK
csbstage=3D#

<= div class=3D"gmail_quote gmail_quote_container">
On Thu, Sep 25, 2025 at 10:08=E2=80=AFAM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Sam Stearns <sam.=E2=80=8Astearns@=E2=80=8Adat.=E2=80=8Acom> writes: = > USAGE has already been granted. [ shrug.=E2=80=8A.=E2=80=8A. ] Apparen= tly not. regards, tom lane =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D = =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D = =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D = =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D = =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80= =8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D = =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2=80=8D =E2= =80=8D
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:
> USAGE has already been granted.

[ shrug... ] Apparently not.

			regards, tom lane


--

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


--000000000000034f4d063fa351df--