Search Postgresql Archives

Re: Large object rights management

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

 



Is there anyone interested on this subject?

Il giorno dom, 05/02/2012 alle 23.30 +0100, Giuseppe Sacco ha scritto:
> 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