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

2024-06-12 Thread Chema
Dear Postgreezers, been banging my head against this one for a couple days. Googling and StackExchange were just as useful, so you're my last hope. I've been unable to get a non-admin user to run Copy From Program even after granting pg_execute_server_program, and everything else I could think o

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

2024-06-12 Thread Chema
> > > 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!