On Wed, Sep 11, 2013 at 10:19 AM, James Sewell <james.sew...@lisasoft.com>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... --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/
