Skip site navigation (1) Skip section navigation (2)

Re: BUG #1830: Non-super-user must be able to copy from a

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Bernard <bht(at)actrix(dot)gen(dot)nz>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-bugs(at)postgresql(dot)org,pgsql-general(at)postgresql(dot)org
Subject: Re: BUG #1830: Non-super-user must be able to copy from a
Date: 2005-08-19 04:19:54
Message-ID: 20050818211012.A2341@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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?

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-08-19 04:57:23
Subject: Re: [GENERAL] BUG #1830: Non-super-user must be able to copy from a
Previous:From: Andrew - SupernewsDate: 2005-08-19 04:17:16
Subject: Re: BUG #1830: Non-super-user must be able to copy from a file

pgsql-general by date

Next:From: Tom LaneDate: 2005-08-19 04:57:23
Subject: Re: [GENERAL] BUG #1830: Non-super-user must be able to copy from a
Previous:From: Andrew - SupernewsDate: 2005-08-19 04:17:16
Subject: Re: BUG #1830: Non-super-user must be able to copy from a file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group