Re: permission denied for large object 200936761

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: permission denied for large object 200936761
Дата
Msg-id 467be57b-9ef6-c3a4-227e-f403ec1b5d68@hot.ee
обсуждение исходный текст
Ответ на Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general

Hi!

> What code changed between the last backup and today?

I have imported data from other clusters and executed lot of different sql commands.  I have used grant, revoke, reassign commands to change privileges for other users and have deleted and added users.

Cluster contains 25 databases. There are 50 users executing SELECT, INSERT, UPDATE, DELETE, CREATE, DROP  and similar commands.

dumpuser has rights only to one database and two schemas (public and firma74 ).

You could try some of the functions here:

https://www.postgresql.org/docs/12/lo-funcs.html

to see if you can figure it out.

There is only one function , lo_get() in this page which returns data. I tried

select * from lo_get(200936761);

select * from lo_get(200936762);

select * from lo_get(200936767);

Those queries returned one row containing one zero-length column lo_get.

Andrus.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: permission denied for large object 200936761
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: permission denied for large object 200936761