Re: About permissions on large objects - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: About permissions on large objects
Date
Msg-id 1310596748.3546.5.camel@laptop
Whole thread Raw
In response to Re: About permissions on large objects  (Howard Cole <howardnews@selestial.com>)
List pgsql-general
On Wed, 2011-07-13 at 23:30 +0100, Howard Cole wrote:
> On 13/07/2011 8:15 PM, Giuseppe Sacco wrote:
> >
> > Is there any other possibility?
>
> Hi Guiseppe,
>
> Perhaps you can create a trigger that monitors for the insertion of an
> oid and then grant permissions. No idea if this can be done, but if it
> can it will save you lots of repeated grants.
>

Large Objects are inserted in a system table. And you cannot add
triggers to system tables. So this can't work.


--
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com


pgsql-general by date:

Previous
From: Joseph Marlin
Date:
Subject: Re: Web-based Graphical Query Building Tool for PostgreSQL
Next
From: Tony Wang
Date:
Subject: Re: Weird problem that enormous locks