lo and security - Mailing list pgsql-general

From Thomas T. Thai
Subject lo and security
Date
Msg-id Pine.NEB.4.21.0105180254300.17302-100000@ns01.minnesota.com
Whole thread Raw
Responses Re: lo and security  (Einar Karttunen <ekarttun@cs.Helsinki.FI>)
List pgsql-general
i'm making a photo album app with php4 and pgsql. i came across something
i think could be a security risk.

i have a web page with a form for user to upload their image, then using
INSERT and lo_import() i get the file to the right location. the problem
is this, with one postmaster running as uid pgsql, that would allow any
other developer to view my data just by guessing the path to my images
cause they all get read by user pgsql.

how do i circumvent this?


pgsql-general by date:

Previous
From: "Dr. Evil"
Date:
Subject: Various locking questions
Next
From: Einar Karttunen
Date:
Subject: Re: lo and security