| From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
|---|---|
| To: | James Sewell <james(dot)sewell(at)lisasoft(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_largeobjects |
| Date: | 2013-09-11 08:40:34 |
| Message-ID: | CA+h6Ahh=Rn3igOX=-DmXGU824tJdvFePWGsaAfQYrWcKoJ-QuQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Sep 11, 2013 at 10:19 AM, James Sewell <james(dot)sewell(at)lisasoft(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Singh Raghuwanshi | 2013-09-11 08:47:09 | Re: [GENERAL] problem in installation of postgresql-jdbc |
| Previous Message | Albe Laurenz | 2013-09-11 08:25:55 | Re: [pgeu-general] Call for design: PostgreSQL mugs |