Re: [BUGS] BUG #1830: Non-super-user must be able to copy from a - Mailing list pgsql-general

From Stephan Szabo
Subject Re: [BUGS] BUG #1830: Non-super-user must be able to copy from a
Date
Msg-id 20050818211012.A2341@megazone.bigpanda.com
Whole thread Raw
In response to Re: [BUGS] BUG #1830: Non-super-user must be able to copy from a file  (Bernard <bht@actrix.gen.nz>)
Responses Re: [BUGS] BUG #1830: Non-super-user must be able to copy from a  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
On Fri, 19 Aug 2005, Bernard wrote:

> My suggestions for improving the COPY command so it can be used by
> non-superuser users would be as follows:

If you want to do this without switching to a different UNIX user, can't
you already write a small SECURITY DEFINER function as a superuser that
does the copy from file based on arguments and then give permissions to
that function to the appropriate non-superusers?

pgsql-general by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: [BUGS] BUG #1830: Non-super-user must be able to copy from a
Next
From: Oliver Elphick
Date:
Subject: Re: How to determine table schema in trigger function