On Wed, Sep 11, 2013 at 10:19 AM, James Sewell <james.sewell@xxxxxxxxxxxx> wrote:
Hello all,I have a table which makes use of pg_largeobjects. I am inserting rows into the table as user1. If I connect to the database as user2 I can SELECT data, but can not open the large object for reading (user1 can do this). I don't want to set lo_compat_privileges as then user3 (who can't SELECT from the services tables) would be able to read the large object.
GRANT SELECT,UPATE ON LARGE OBJECT to user2;
Will this work...
