Re: permission denied for large object 200936761 - Mailing list pgsql-general

From Andrus
Subject Re: permission denied for large object 200936761
Date
Msg-id eff2a916-379c-128c-0f62-e229fa4b8716@hot.ee
Whole thread Raw
In response to Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: permission denied for large object 200936761
List 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 by date:

Previous
From: Helmut Bender
Date:
Subject: Segmentation fault on startup
Next
From: Adrian Klaver
Date:
Subject: Re: permission denied for large object 200936761