Search Postgresql Archives

Large object rights management

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux