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 1v1pAB-00D1gc-Nz for pgsql-admin@arkaria.postgresql.org; Thu, 25 Sep 2025 16:49:47 +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 1v1pAA-003qVK-6V for pgsql-admin@arkaria.postgresql.org; Thu, 25 Sep 2025 16:49:46 +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 1v1pA9-003qV4-Ph for pgsql-admin@lists.postgresql.org; Thu, 25 Sep 2025 16:49:45 +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 1v1pA5-0003O7-2A for pgsql-admin@lists.postgresql.org; Thu, 25 Sep 2025 16:49:44 +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 58PEFq1u1812353 for ; Thu, 25 Sep 2025 09:49:38 -0700 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dat.com; h=cc :content-type:date:from:message-id:mime-version:subject:to; s= ppdk230404; bh=9Gn3d1xNxs3VHxbHUwX6KYvl9yovzxUHlXCCFPNEYHM=; b=A mn8aUMyPWUjJQghdGSh+NSWosvA/FCcMF1Cq+Fnqx5mlv7FQXf4jl0N031wZfjE3 eQwgNah9KFJ/Oe/5zCbIME/rpuexk03vbVMZI9XbwDmYec7z1Vl4pjAu0uooCsiG Qnb92fiUTGSdkgc9t3sGKQ+6uDfAR8dP7Xxc2ZoZZthValwKBfdh8n7nToRED4Eo ETvj9j2gemhVp+JqIilrJfbg7rvDzDRZ8WXZSVxOZHFYIbDm3vqqXwmHaEFGizLv SZVy5Otbp+r7Qdjkn0e6Ca43UWxxMXTWvGDtj5UEQjcKjzWMy1IeRrFoLy6YoDTS c5LGfT64QVfvxDuq7KAPA== Received: from mail-ej1-f71.google.com (mail-ej1-f71.google.com [209.85.218.71]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 499td1qhmg-1 (version=TLSv1.3 cipher=TLS_AES_128_GCM_SHA256 bits=128 verify=NOT) for ; Thu, 25 Sep 2025 09:49:38 -0700 (PDT) Received: by mail-ej1-f71.google.com with SMTP id a640c23a62f3a-b2c76083936so129077766b.2 for ; Thu, 25 Sep 2025 09:49:38 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758818976; x=1759423776; h=cc:to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=9Gn3d1xNxs3VHxbHUwX6KYvl9yovzxUHlXCCFPNEYHM=; b=FlqrWsN8kXhhuC33Fq9g18sjpBbkjoxmaiKiKsbxkEvvpyZhijWiYuRyG4x7nm3PBg v+tYiLcqCuVVr9dGKOzAksO7cxGw9Qk6WASDFfhzymsrpUFDTSlkRxsTdK5S6Rm9kMgg JypVfpxrrrEzBn8bowg6NcNWGXOtLyN1M3otk5w9pU0AkilDvHDOZeOF8U7XsbOsJJrg KNJrigixNV7fCjyPKRiEBEDEVFOnXY0liMz5JPo+eHE2mfMEalZwqW4o6BtnzwkVdkY/ 0Oyrc02cxNFXm7tiNVuzAIcf7Rh+64wTh0OWoxS16Q0Iv1uBQZ7phqZfv4Nn6Rtn3tU/ ePpA== X-Gm-Message-State: AOJu0Yzokv45e8lQms+mt/sov4APZcO6xfBWkTU+9c2KljVbF07GsNVQ giHWZ9MFSSmT4sFDLtDlZ3EaMz2zbB1IGeUSj5ZRaTZQTVvYcQIYIfd5yQrvZ6QBKKr8KxOZoks khRp154hvn2+khEuBYLAhUFmNMyQL+g1M9TKNuP61gmc/i9NU+qNvyxUHlrHlq4qIG1WjTRGgQ6 TWAwLYeknB61IlXVxAXQGN7vKZxV0h2AjKJhNkXoFcCp8OoCQIM5t6u701yZk1iEkAdjC//N8/T cbjZ7rTQg== X-Gm-Gg: ASbGncs6ydwmYjuLTnnHsiYCvvTOZrMoDEErXdAl+Ucvi/iPKxsmSc2CGBJac5uY5eF bPGcYjgb17IiJgyQtrDWmv2SpN6pnUURAClBTe21yi4O10GAkEYwd5BaZORcx+qsbLz5SwWkMgl A8WzHQNc/MzD+f7QfmOtA= X-Received: by 2002:a17:906:6a0a:b0:b04:85f2:d272 with SMTP id a640c23a62f3a-b34bc97172cmr436777966b.49.1758818975944; Thu, 25 Sep 2025 09:49:35 -0700 (PDT) X-Google-Smtp-Source: AGHT+IE4+1/iHl4q+bMp4fdtIAk+vOLebbHjxedvI3+8olR1gIW5xn/TQ2+83vY0ZKZobuI17ae8ltcFz7QwT49FE3M= X-Received: by 2002:a17:906:6a0a:b0:b04:85f2:d272 with SMTP id a640c23a62f3a-b34bc97172cmr436775866b.49.1758818975480; Thu, 25 Sep 2025 09:49:35 -0700 (PDT) MIME-Version: 1.0 From: Sam Stearns Date: Thu, 25 Sep 2025 09:49:24 -0700 X-Gm-Features: AS18NWCBL7zeX6mEUCgTD1R1LUNE13okO1ynX9b6PkyFM_9F149K-v8r75hWPsE Message-ID: Subject: INSERT Permission Denied To: Pgsql-admin Cc: Dugan Kniesteadt , Henry Ashu , Avi Vallarapu Content-Type: multipart/alternative; boundary="000000000000420fe3063fa2f46c" 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 --000000000000420fe3063fa2f46c Content-Type: text/plain; charset="UTF-8" Howdy, I have an INSERT: INSERT INTO treg.cd_combined_office_mappings ( tcsi_office_id, combined_office_id, sb2_account_id, postal_code, category, account_name, city, state, is_preferred, is_closed, is_parent ) VALUES ('TCSI001', 10001, 2001, '90210', 'RETAIL', 'Acme Corp', 'Los Angeles', 'CA', 'Y', 'N', 'Y'), ('TCSI002', 10001, 2002, '10001', 'WHOLESALE', 'Beta LLC', 'New York', 'NY', 'N', 'N', 'N'), ('TCSI003', 10002, 2003, '60601', 'RETAIL', 'Gamma Inc', 'Chicago', 'IL', 'Y', 'N', 'N'), ('TCSI004', 10003, 2004, '77001', 'SERVICE', 'Delta Co', 'Houston', 'TX', 'N', 'Y', 'N'), ('TCSI005', 10003, 2005, '33101', 'RETAIL', 'Epsilon Ltd', 'Miami', 'FL', 'Y', 'N', 'Y'); 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... ^ QUERY: SELECT 1 FROM ONLY "treg"."cd_combined_offices" x WHERE "combined_office_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x Table structure: csbstage=# \d+ treg.cd_combined_office_mappings Table "treg.cd_combined_office_mappings" Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description --------------------+-----------------------+-----------+----------+---------+----------+-------------+--------------+------------- tcsi_office_id | character varying(15) | | not null | | extended | | | combined_office_id | numeric(38,0) | | not null | | main | | | sb2_account_id | integer | | not null | | plain | | | postal_code | character varying(15) | | not null | | extended | | | category | character varying(20) | | not null | | extended | | | account_name | character varying(50) | | not null | | extended | | | city | character varying(50) | | not null | | extended | | | state | character(2) | | not null | | extended | | | is_preferred | character(1) | | not null | | extended | | | is_closed | character(1) | | not null | | extended | | | is_parent | character(1) | | not null | | extended | | | Indexes: "cd_combined_office_mappings_pkey" PRIMARY KEY, btree (tcsi_office_id) "idx_combined_mappings_1" btree (combined_office_id) "idx_combined_mappings_2" btree (sb2_account_id) Foreign-key constraints: "cd_combined_mappings" FOREIGN KEY (combined_office_id) REFERENCES treg.cd_combined_offices(combined_office_id) NOT VALID Publications: "csbstage_postgres_to_oracle" Replica Identity: FULL Access method: heap The user has all required privileges from what I can tell. The postgres user even gets the same failure when running the INSERT. Would anyone be able to give any advice here, please? Thanks, Sam -- Samuel Stearns Team Lead - Database c: 971 762 6879 | o: 971 762 6879 | DAT.com --000000000000420fe3063fa2f46c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Howdy,

I have an INSERT:=

INSERT INTO treg.cd_combined_office_mappings (
=C2= =A0 =C2=A0 tcsi_office_id, combined_office_id, sb2_account_id, postal_code,= category,
=C2=A0 =C2=A0 account_name, city, state, is_preferred, is_clo= sed, is_parent
) VALUES
('TCSI001', 10001, 2001, '90210&#= 39;, 'RETAIL', 'Acme Corp', 'Los Angeles', 'CA&= #39;, 'Y', 'N', 'Y'),
('TCSI002', 10001,= 2002, '10001', 'WHOLESALE', 'Beta LLC', 'New Y= ork', 'NY', 'N', 'N', 'N'),
('TC= SI003', 10002, 2003, '60601', 'RETAIL', 'Gamma Inc&= #39;, 'Chicago', 'IL', 'Y', 'N', 'N'= ;),
('TCSI004', 10003, 2004, '77001', 'SERVICE',= 'Delta Co', 'Houston', 'TX', 'N', 'Y&#= 39;, 'N'),
('TCSI005', 10003, 2005, '33101', = 9;RETAIL', 'Epsilon Ltd', 'Miami', 'FL', 'Y= ', 'N', 'Y');


that= 9;s failing with permission denied on the schema:

= ERROR: =C2=A0permission denied for schema treg
LINE 1: SELECT 1 FROM ONL= Y "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&quo= t;."cd_combined_offices" x WHERE "combined_office_id" O= PERATOR(pg_catalog.=3D) $1 FOR KEY SHARE OF x


=
Table structure:

csbstage=3D# \d+ treg.= cd_combined_office_mappings
=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 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Table "treg.cd_combined_o= ffice_mappings"
=C2=A0 =C2=A0 =C2=A0 =C2=A0Column =C2=A0 =C2=A0 =C2= =A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 Type =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = Collation | Nullable | Default | Storage =C2=A0| Compression | Stats target= | Description
--------------------+-----------------------+-----------+= ----------+---------+----------+-------------+--------------+-------------<= br>=C2=A0tcsi_office_id =C2=A0 =C2=A0 | character varying(15) | =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 | not null | =C2=A0 =C2=A0 =C2=A0 =C2=A0 | extende= d | =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=A0combined_office_id | numeric(38,0) =C2=A0 = =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | not null | =C2= =A0 =C2=A0 =C2=A0 =C2=A0 | main =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 =C2=A0|
=C2= =A0sb2_account_id =C2=A0 =C2=A0 | integer =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | not null | =C2=A0 = =C2=A0 =C2=A0 =C2=A0 | plain =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 =C2=A0|
=C2=A0pos= tal_code =C2=A0 =C2=A0 =C2=A0 =C2=A0| character varying(15) | =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 | not null | =C2=A0 =C2=A0 =C2=A0 =C2=A0 | extended |= =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=A0category =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = | character varying(20) | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | not null | = =C2=A0 =C2=A0 =C2=A0 =C2=A0 | extended | =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=A0accoun= t_name =C2=A0 =C2=A0 =C2=A0 | character varying(50) | =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 | not null | =C2=A0 =C2=A0 =C2=A0 =C2=A0 | extended | =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=A0city =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = | character varying(50) | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | not null | = =C2=A0 =C2=A0 =C2=A0 =C2=A0 | extended | =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=A0state = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| character(2) =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | not null | = =C2=A0 =C2=A0 =C2=A0 =C2=A0 | extended | =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=A0is_pre= ferred =C2=A0 =C2=A0 =C2=A0 | character(1) =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | not null | =C2=A0 =C2=A0 =C2=A0 = =C2=A0 | extended | =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=A0is_closed =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0| character(1) =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | not null | =C2=A0 =C2=A0 =C2=A0 =C2=A0 | = extended | =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=A0is_parent =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0| character(1) =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 | not null | =C2=A0 =C2=A0 =C2=A0 =C2=A0 | extended | = =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|
Indexes:
=C2=A0 =C2=A0 "cd_combined_office_ma= ppings_pkey" PRIMARY KEY, btree (tcsi_office_id)
=C2=A0 =C2=A0 &quo= t;idx_combined_mappings_1" btree (combined_office_id)
=C2=A0 =C2=A0= "idx_combined_mappings_2" btree (sb2_account_id)
Foreign-key = constraints:
=C2=A0 =C2=A0 "cd_combined_mappings" FOREIGN KEY = (combined_office_id) REFERENCES treg.cd_combined_offices(combined_office_id= ) NOT VALID
Publications:
=C2=A0 =C2=A0 "csbstage_postgres_to_or= acle"
Replica Identity: FULL
Access method: heap

<= /div>

The user has all required privileges from what I c= an tell.=C2=A0 The postgres user even gets the same failure when running th= e INSERT.=C2=A0 Would anyone be able to give any advice here, please?
=

Thanks,

Sam

=

--

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 <= span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(147,149= ,152);background-color:transparent;vertical-align:baseline">| DAT.com


--000000000000420fe3063fa2f46c--