Postgres Pro
Downloads
Home   >   mailing lists

Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program - Mailing list pgsql-general

From David G. Johnston
Subject Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Date
Msg-id CAKFQuwadEpozBwUp36ts7wR30J-r=FxUV5_1LHCfkXE_Czb6jA@mail.gmail.com
Whole thread Raw
In response to "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program  (Chema <chema@interneta.org>)
Responses Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
List pgsql-general
Tree view


On Wednesday, June 12, 2024, Chema <chema@interneta.org> wrote:

Create Role justintestin noinherit login password 'qwer';


GRANT pg_execute_server_program TO justintestin;



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.
 

pgsql-general by date:

Previous
From: Chema
Date:
Subject: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Next
From: Tom Lane
Date:
Subject: Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program