Re: permission denied for large object 200936761

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: permission denied for large object 200936761
Дата
Msg-id eff2a916-379c-128c-0f62-e229fa4b8716@hot.ee
обсуждение исходный текст
Ответ на Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: permission denied for large object 200936761
Список pgsql-general

Hi!

>Large objects exist independent of those. The important part of the above is lomowner. Use that oid to find the role that owns the objects here:

select rolname from pg_roles where oid = 30152 ;

returns my role ,  clusteradmin . I have superuser rights:

CREATE ROLE clusteradmin WITH
  LOGIN
  SUPERUSER
  INHERIT
  NOCREATEDB
  NOCREATEROLE
  NOREPLICATION:

GRANT db1_owner, db2_owner, ... to  clusteradmin;

It havent created any large objects.

How to use this information to fix the issue ?
Andrus.

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