Re: About "ERROR: must be *superuser* to COPY to or from a file" - Mailing list pgsql-general

From Tom Lane
Subject Re: About "ERROR: must be *superuser* to COPY to or from a file"
Date
Msg-id 15067.1125359993@sss.pgh.pa.us
Whole thread Raw
In response to Re: About "ERROR: must be *superuser* to COPY to or from a file"  (Greg Stark <gsstark@mit.edu>)
Responses Re: About "ERROR: must be *superuser* to COPY to or from  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> I was only suggesting using this from a local unix user where you can
> actually authoritatively say something about the uid of the connecting
> user. I suggested that if the owner of the file matches the uid of the
> connecting user (which you can get on a unix domain socket)

... on some platforms ... and half the world connects over TCP even on
local connections ...

> then there's no reason not to grant access to the file.

Assuming that the server itself can get at the file, which is
questionable if the file is owned by the connecting user rather than the
server (and, for instance, may be located under a not-world-readable
home directory).  And then there are interesting questions like whether
the server and the user see eye-to-eye on the name of the file (consider
server inside chroot jail, AFS file systems, etc).

There are enough holes in this to make it less than attractive.  We'd
spend more time answering questions about "why doesn't this work" than
we do now, and I remain unconvinced that there would be no exploitable
security holes.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: About dropped notifications
Next
From: Clodoaldo Pinto
Date:
Subject: update functions locking tables