lo_ and SU privs - Mailing list pgsql-general

From Bell John
Subject lo_ and SU privs
Date
Msg-id 20011015080219.86714.qmail@web12602.mail.yahoo.com
Whole thread Raw
Responses Re: lo_ and SU privs  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: lo_ and SU privs  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Under PostgreSQL 7.1.3 (RH Linux 7.1 platform) I get
the following whenever trying to manipulate large
objects either from psql or sql oriented API's (eg.
PoPy, psycopg, pypgsql (DPAPI kit)):

You must have Postgres superuser privilege to use
server-side lo_import.  Anyone can use the client-side
lo_import provided by libpq.

Is there any way to disable this behaviour or to give
a user the priviliges that are being looked for?  This
effectively cripples the vast majority of programmatic
interfaces to PostgreSQL ie. all those that are more
than wrappers around libpq.

John

__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Reading psql password from stdin
Next
From: Denis Gasparin
Date:
Subject: Re: VACUUM, 24/7 availability and 7.2