Re: pg_largeobjects

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: pg_largeobjects
Дата
Msg-id CA+h6Ahh=Rn3igOX=-DmXGU824tJdvFePWGsaAfQYrWcKoJ-QuQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_largeobjects  (James Sewell <james.sewell@lisasoft.com>)
Ответы Re: pg_largeobjects  (James Sewell <james.sewell@lisasoft.com>)
Список 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 по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: [pgeu-general] Call for design: PostgreSQL mugs
Следующее
От: Vivek Singh Raghuwanshi
Дата:
Сообщение: Re: problem in installation of postgresql-jdbc