Re: How to stop script executions - Mailing list pgsql-general

From David G. Johnston
Subject Re: How to stop script executions
Date
Msg-id CAKFQuwb32eBEEc=CthxA+TxJkFVn2Ekdg9n2OvE-sK4qAt13MA@mail.gmail.com
Whole thread Raw
In response to Re: How to stop script executions  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: How to stop script executions  (Dev Kumkar <devdas.kumkar@gmail.com>)
List pgsql-general
On Tue, Jul 26, 2016 at 9:48 AM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
On Tue, Jul 26, 2016 at 6:54 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
​Superuser: yes (specifically I'm thinking the COPY FROM PROGRAM command, but also C language functions)
Ordinary user: not that I can think of.

OK, is there a way to restrict usage of COPY FROM PROGRAM command?


​For superusers, no.  You'd have to protect the system using external tools to limit what areas and commands the postgres (or whatever PostgreSQL runs as) user ​can access.

​David J.​

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: How to stop script executions
Next
From: John McKown
Date:
Subject: Re: How to stop script executions