Re: About permissions on large objects

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