Обсуждение: PG 9.0 large object permissions

Hi all,

Having a little problem with my large objects.  In 8.4 the db owner was
'andy', but my web connected as payuser (which had appropriate permissions).

The backup/restore to pg9 made all the large objects owned by 'andy',
and I'm guessing payuser does not have select rights.

GRANT seems to support large objects, but only one at a time.
http://www.postgresql.org/docs/current/static/sql-grant.html

and ALTER DEFAULT PRIVILEGES seems to do many at a time, but doesnt to
large objects.

I really don't care if I get the owner changed or add r/w writes.  (I'd
prefer the owner, if I got to choose).

Any hints?  Please?

-Andy

Andy Colson <andy@squeakycode.net> writes:
> Having a little problem with my large objects.  In 8.4 the db owner was
> 'andy', but my web connected as payuser (which had appropriate permissions).

> The backup/restore to pg9 made all the large objects owned by 'andy',
> and I'm guessing payuser does not have select rights.

If you just want it to work like it did before, I believe there's a server
parameter you can change to disable permissions checks on large objects.

            regards, tom lane