Large object rights management

Started by Giuseppe Saccoabout 14 years ago2 messagesgeneral
Jump to latest
#1Giuseppe Sacco
giuseppe@eppesuigoccas.homedns.org

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

#2Giuseppe Sacco
giuseppe@eppesuigoccas.homedns.org
In reply to: Giuseppe Sacco (#1)
Re: Large object rights management

Is there anyone interested on this subject?

Il giorno dom, 05/02/2012 alle 23.30 +0100, Giuseppe Sacco ha scritto:

Show quoted text

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