Re: pg_largeobjects - Mailing list pgsql-general

From Raghavendra
Subject Re: pg_largeobjects
Date
Msg-id CA+h6Ahh=Rn3igOX=-DmXGU824tJdvFePWGsaAfQYrWcKoJ-QuQ@mail.gmail.com
Whole thread Raw
In response to pg_largeobjects  (James Sewell <james.sewell@lisasoft.com>)
Responses Re: pg_largeobjects  (James Sewell <james.sewell@lisasoft.com>)
List pgsql-general


On Wed, Sep 11, 2013 at 10:19 AM, James Sewell <james.sewell@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

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: [pgeu-general] Call for design: PostgreSQL mugs
Next
From: Vivek Singh Raghuwanshi
Date:
Subject: Re: problem in installation of postgresql-jdbc