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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sHZfK-009Fpy-Gr
	for pgsql-general@arkaria.postgresql.org; Thu, 13 Jun 2024 01:54:14 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sHZfI-00BJnk-5q
	for pgsql-general@arkaria.postgresql.org; Thu, 13 Jun 2024 01:54:13 +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 <cateter@gmail.com>)
	id 1sHZfH-00BJnK-Qf
	for pgsql-general@lists.postgresql.org; Thu, 13 Jun 2024 01:54:12 +0000
Received: from mail-oo1-f51.google.com ([209.85.161.51])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <cateter@gmail.com>)
	id 1sHZfG-001OEK-AI
	for pgsql-general@lists.postgresql.org; Thu, 13 Jun 2024 01:54:12 +0000
Received: by mail-oo1-f51.google.com with SMTP id 006d021491bc7-5b970e90ab8so296536eaf.3
        for <pgsql-general@lists.postgresql.org>; Wed, 12 Jun 2024 18:54:10 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1718243648; x=1718848448;
        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=g5TyHyuWKoSu5GuKQsdg2ISr0jQx8GjnKxvs4weQVaQ=;
        b=AvH4+tfdonnwJxslRdFQDOlHks2Ml6Ycu0LNKs+BDmguD++3qgzLZcLyhPUOJYGGXe
         3by0bh4knE3o1qkzS7eYtvigK1s5Dx6IyFr6HnM7RLsh4V6whZLNLz6+OUSiVhEvg3nd
         ZXyIMd1NL0JKaxIEfN1lHJbmgAV1d4lo9JUV0ajteGr2Yq49ZtHTSAYqdmKao+RB62eB
         TAmH2UQGNho5S6xVvhU6PM4vU4qF/LZYaTpRTjO+1LAYCCa9+tkktcvFBQW2m9tLpdtR
         g+17OnosyXzmEhiF+oC2w0vJarse6qaICsHcC68NOClcsU4Fs3lg2gPUIS1zRuiHcyU2
         jJjg==
X-Gm-Message-State: AOJu0YyaWg0Pcs6AuCtkO+te0/SuChQM2EKw8cJ5mocDGz3Q/wXlufPB
	ykuPd/AvfGCzfb3pk+mnVH4hvb+6nGmtXWTmCpoZQq253cajRd7D9vXiXr5UF0/ZLwY12aS7TwD
	3xWFLkdHJhr+ca5q35o9bW+mib5+weA==
X-Google-Smtp-Source: AGHT+IEuXx3r7JZrPwY5+3EN0lmFx+aYjuNQ9KHo9XCwddTe/5xb8tP3SP+lzRhYO34j4MPsBPePB5hHOQZ4jeBB1tc=
X-Received: by 2002:a05:6820:220a:b0:5bb:3ab6:94d8 with SMTP id
 006d021491bc7-5bb3ba560ffmr4536624eaf.6.1718243648203; Wed, 12 Jun 2024
 18:54:08 -0700 (PDT)
MIME-Version: 1.0
References: <CALdEsqOM2q7bXt1Bo2S_41nHgSjR2_epzm=aHHFoHsQdzB3fqQ@mail.gmail.com>
 <CAKFQuwadEpozBwUp36ts7wR30J-r=FxUV5_1LHCfkXE_Czb6jA@mail.gmail.com>
In-Reply-To: <CAKFQuwadEpozBwUp36ts7wR30J-r=FxUV5_1LHCfkXE_Czb6jA@mail.gmail.com>
From: Chema <chema@interneta.org>
Date: Wed, 12 Jun 2024 19:53:43 -0600
Message-ID: <CALdEsqPZTQFEtBsn2XB4dYuTQ6V4Uj65rrwk3ibqy3eDP59ivQ@mail.gmail.com>
Subject: Re: "permission denied to COPY to or from an external program" even
 with GRANT pg_execute_server_program
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000049f361061abbc6f1"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CALdEsqPZTQFEtBsn2XB4dYuTQ6V4Uj65rrwk3ibqy3eDP59ivQ%40mail.gmail.com>
Precedence: bulk

--00000000000049f361061abbc6f1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

>
>
> Pretty sure since you choose not to allow justintestin to inherit stuff
> you will need to issue a =E2=80=9Cset role to pg_execute_server_program=
=E2=80=9D before you
> attempt the copy command.
>
> David J.
>

That was it!  Blind paranoia bites my rear again.  Thanks!

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

<div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex"><div><br></div><div>Pretty sure since you choose not to =
allow justintestin to inherit stuff you will need to issue a =E2=80=9Cset r=
ole to pg_execute_server_program=E2=80=9D before you attempt the copy comma=
nd.</div><div><br></div><div>David J.</div></blockquote><div><br></div><div=
 class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;font-size:=
large;color:rgb(68,68,68)">That was it!=C2=A0 Blind paranoia bites my rear =
again.=C2=A0 Thanks!</div></div></div>

--00000000000049f361061abbc6f1--