Large object rights management

From: Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Large object rights management
Date: 2012-02-05 22:30:04
Message-ID: 1328481004.4571.9.camel@scarafaggio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I wrote an application that store a large quantity of files in the
database as large binary objects. There are around 50 tables (all in one
schema) and only one table host all these large objects. Every user
connect to database using his own user, so all users are parts of the
same group role for granting permissione to every application user.

My problem is about large object permissions introduced in postgresql
9.0, since my application permits to everyone to insert/update/delete
any large object. Now, since 9.0, deleting a large object is only
possible for the user that owns it.

I know that 9.0 also introduced an option for reverting this behaviour
as it was in 8.4, but I wonder if there is any other way of sharing and
deleting large objects in 9.0.

Thanks,
Giuseppe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zhong ming wu 2012-02-05 23:32:08 .psql_history file is messed up and control-r does not work
Previous Message Tom Lane 2012-02-05 17:39:55 Re: vacuumlo fails pgsql ver 8.3