Re: About permissions on large objects

From: Howard Cole <howardnews(at)selestial(dot)com>
To: Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: About permissions on large objects
Date: 2011-07-13 22:30:41
Message-ID: 4E1E1C91.2080305@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2011-07-13 22:39:07 Re: About permissions on large objects
Previous Message Lars Kanis 2011-07-13 19:53:09 Re: Using LDAP roles in PostgreSQL