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

From Howard Cole
Subject Re: About permissions on large objects
Date
Msg-id 4E1E1C91.2080305@selestial.com
Whole thread Raw
In response to Re: About permissions on large objects  (Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>)
Responses Re: About permissions on large objects  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: About permissions on large objects  (Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>)
List pgsql-general
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.

An easier option to use the compatibility option and then, when you have
updated your code, you can turn off the compatibility mode and run your
script once.

Howard Cole
www.selestial.com

pgsql-general by date:

Previous
From: Giuseppe Sacco
Date:
Subject: Re: About permissions on large objects
Next
From: "Lars Kanis"
Date:
Subject: Re: Using LDAP roles in PostgreSQL