PG 9.0 large object permissions

Started by Andy Colsonover 15 years ago2 messagesgeneral
Jump to latest
#1Andy Colson
andy@squeakycode.net

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andy Colson (#1)
Re: PG 9.0 large object permissions

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