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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs 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?

In response to

Responses

Browse pgsql-bugs by date

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

Browse pgsql-general by date

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