MIME-Version: 1.0
From: Sam Stearns <sam.stearns@dat.com>
Date: Fri, 27 Jun 2025 08:11:00 -0700
Message-ID: 
 <CAN6TVj=MxX_FgXzvZLxLHXyvzFRzpX2JFyug5mwOvteLoG4qLg@mail.gmail.com>
Subject: Permission Denied on INSERT
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Cc: Julie Mather <julie.mather@dat.com>, Peter Garza <peter.garza@dat.com>,
        Henry Ashu <henry.ashu@dat.com>
Content-Type: multipart/alternative; boundary="0000000000009c2b9006388f161b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVj%3DMxX_FgXzvZLxLHXyvzFRzpX2JFyug5mwOvteLoG4qLg%40mail.gmail.com>
Precedence: bulk

--0000000000009c2b9006388f161b
Content-Type: text/plain; charset="UTF-8"

Howdy,

We're getting a permission denied error on an INSERT and cannot figure out
why:


*[postgres@thiludbapql01 log]$ psql -U treg csbtestPassword for user
treg:psql (16.6)Type "help" for help.csbtest=# show search_path;
search_path---------------------------- csbtfsprd, interface, treg(1
row)csbtest=# grant usage on schema treg to treg;GRANTcsbtest=# GRANT
SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA treg TO
treg;GRANTcsbtest=# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA treg TO
treg;GRANTcsbtest=# GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA treg TO
treg;GRANTcsbtest=# insert into treg.cd_combined_office_mappings
(combined_office_id, tcsi_office_id, sb2_account_id, account_name, city,
postal_code, state, category, is_preferred, is_closed, is_parent)csbtest-#
values (('734309'::int8),('S.668863.785512'),('668863'::int4),('Testing
Something'),('Beaverton'),('97008'),('OR'),('Carrier'),('Y'),('N'),('Y'));ERROR:
 permission denied for schema tregLINE 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 xcsbtest=#*


Any help would be greatly appreciated, please.

Thank you,

Sam

-- 

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com

<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>

--0000000000009c2b9006388f161b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Howdy,</div><div><br></div><div>We&#39;re getting a p=
ermission denied error on an INSERT and cannot figure out why:<br><br><i>[p=
ostgres@thiludbapql01 log]$ psql -U treg csbtest<br>Password for user treg:=
<br>psql (16.6)<br>Type &quot;help&quot; for help.<br><br>csbtest=3D# show =
search_path;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 search_path<br>----------------=
------------<br>=C2=A0csbtfsprd, interface, treg<br>(1 row)<br><br>csbtest=
=3D# grant usage on schema treg to treg;<br>GRANT<br>csbtest=3D# GRANT SELE=
CT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA treg TO treg;<br>GRANT<b=
r>csbtest=3D# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA treg TO treg;<=
br>GRANT<br>csbtest=3D# GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA treg TO tr=
eg;<br>GRANT<br>csbtest=3D# insert into treg.cd_combined_office_mappings (c=
ombined_office_id, tcsi_office_id, sb2_account_id, account_name, city, post=
al_code, state, category, is_preferred, is_closed, is_parent)<br>csbtest-# =
values ((&#39;734309&#39;::int8),(&#39;S.668863.785512&#39;),(&#39;668863&#=
39;::int4),(&#39;Testing Something&#39;),(&#39;Beaverton&#39;),(&#39;97008&=
#39;),(&#39;OR&#39;),(&#39;Carrier&#39;),(&#39;Y&#39;),(&#39;N&#39;),(&#39;=
Y&#39;));<br>ERROR: =C2=A0permission denied for schema treg<br>LINE 1: SELE=
CT 1 FROM ONLY &quot;treg&quot;.&quot;cd_combined_offices&quot; x WHERE &qu=
ot;com...<br>=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^<br>QUERY: =C2=A0SELECT 1 FROM ONLY &qu=
ot;treg&quot;.&quot;cd_combined_offices&quot; x WHERE &quot;combined_office=
_id&quot; OPERATOR(pg_catalog.=3D) $1 FOR KEY SHARE OF x<br>csbtest=3D#</i>=
</div><div><i><br></i></div><div><br></div><div>Any help would be greatly a=
ppreciated, please.</div><div><br></div><div>Thank you,</div><div><br></div=
><div>Sam</div><div><br></div><span class=3D"gmail_signature_prefix">-- </s=
pan><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_=
signature"><div dir=3D"ltr"><span><p dir=3D"ltr" style=3D"line-height:1.38;=
margin-top:10pt;margin-bottom:10pt"><span style=3D"font-size:11pt;font-fami=
ly:Inter,sans-serif;color:rgb(51,51,51);background-color:transparent;font-w=
eight:700;vertical-align:baseline">Samuel Stearns</span><span style=3D"font=
-size:11pt;font-family:Inter,sans-serif;color:rgb(51,51,51);background-colo=
r:transparent;font-weight:700;vertical-align:baseline"><br></span><span sty=
le=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);ba=
ckground-color:transparent;vertical-align:baseline">Team Lead - Database</s=
pan><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(10=
2,102,102);background-color:transparent;vertical-align:baseline"><br></span=
><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,1=
02,102);background-color:transparent;vertical-align:baseline">c: 971 762 68=
79 </span><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:=
rgb(147,149,152);background-color:transparent;vertical-align:baseline">|</s=
pan><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(10=
2,102,102);background-color:transparent;vertical-align:baseline"> o: 971 76=
2 6879 </span><span style=3D"font-size:11pt;font-family:Inter,sans-serif;co=
lor:rgb(147,149,152);background-color:transparent;vertical-align:baseline">=
|</span><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rg=
b(102,102,102);background-color:transparent;vertical-align:baseline"> DAT.c=
om</span></p><p dir=3D"ltr" style=3D"line-height:1.38;margin-top:0pt;margin=
-bottom:0pt"><a href=3D"https://www.dat.com/?utm_medium=3Demail&amp;utm_sou=
rce=3DDAT_email_signature_link" target=3D"_blank"><span style=3D"font-size:=
11pt;font-family:Arial,sans-serif;color:rgb(17,85,204);background-color:tra=
nsparent;vertical-align:baseline"><span style=3D"border:none;display:inline=
-block;overflow:hidden;width:126px;height:54px"><img src=3D"https://lh7-rt.=
googleusercontent.com/docsz/AD_4nXchMTXZiU3P-OkN7UwPyrdxiCAOkHWIArmSrehhAl-=
cXaYxECakbMV5owUfMaMjAZZcbjttr8pEtSGrZjUSRNaxbLxumAthLgYlFE5iT2P2eOJu4jtqiz=
p_fYM0Mq1DZyFUeHMhpGKjiGIzqD_ny_hPIzlt?key=3Dz3dM0-Cr9WzKyLauPVBgWw" width=
=3D"126" height=3D"54" style=3D"margin-left:0px;margin-top:0px"></span></sp=
an></a></p><div><br></div></span></div></div></div>

--0000000000009c2b9006388f161b--