Search Postgresql Archives

Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
From: Chema <chema@xxxxxxxxxxxxx>
Date: Wed, 12 Jun 2024 19:53:43 -0600
Cc: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAKFQuwadEpozBwUp36ts7wR30J-r=FxUV5_1LHCfkXE_Czb6jA@mail.gmail.com>
References: <CALdEsqOM2q7bXt1Bo2S_41nHgSjR2_epzm=aHHFoHsQdzB3fqQ@mail.gmail.com> <CAKFQuwadEpozBwUp36ts7wR30J-r=FxUV5_1LHCfkXE_Czb6jA@mail.gmail.com>

Pretty sure since you choose not to allow justintestin to inherit stuff you will need to issue a “set role to pg_execute_server_program” before you attempt the copy command.

David J.

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
  - From: Chema
- Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
  - From: David G. Johnston

Prev by Date: Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Next by Date: Re: postgres table statistics
Previous by thread: Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Next by thread: Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux