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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Дата
Msg-id CAKFQuwadEpozBwUp36ts7wR30J-r=FxUV5_1LHCfkXE_Czb6jA@mail.gmail.com
обсуждение исходный текст
Ответ на "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program  (Chema <chema@interneta.org>)
Ответы Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Список pgsql-general
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Chema
Дата:
Сообщение: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program