Обсуждение: large objects permission issue
Just found this in the archives: > Andy Colson <andy(at)squeakycode(dot)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 I'm looking for this server parameter. It doesn't seem to be in postgresql.conf. Any pointers? Maximilian Tyrtania Software-Entwicklung Dessauer Str. 6-7 10969 Berlin http://www.contactking.de
Le 14/02/2011 13:05, Maximilian Tyrtania a écrit : > Just found this in the archives: > >> Andy Colson <andy(at)squeakycode(dot)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 > > I'm looking for this server parameter. It doesn't seem to be in postgresql.conf. > Any pointers? > You're looking for lo_compat_privileges. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
I was, thank you very much. I managed to overlook it in postgresql.conf (and send my inquiry to the wrong list on top ofthat, uh.) Maximilian Tyrtania Software-Entwicklung Dessauer Str. 6-7 10969 Berlin http://www.contactking.de >> I'm looking for this server parameter. It doesn't seem to be in postgresql.conf. >> Any pointers? >> > > You're looking for lo_compat_privileges.