As superuser I still can't update a row in one table

From: John Scalia <jayknowsunix(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: As superuser I still can't update a row in one table
Date: 2017-04-24 15:02:11
Message-ID: CABzCKRCnMFgZ36uk5RhoS=2+A=bCKankV934Kd_2RfY9=y6xuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good morning all,

I have a postgresql database used by redhat's spacewalk system that we've
been upgrading. The database's schema-upgrade script failed during our
attempt and I'm trying to clean up. The script errored on the very last
function it tries,and that one invokes another function which is the actual
problem. I altered this function, and got it to write values to it's table,
but they're the wrong values. So now, I'm trying to just run some simple
updates on the table and this is failing.

I'm logged into the database as a Superuser. Here's the sequence from psql:

rhnschema=# \du s45198
List of roles
Role name | Attributes | Member of
-----------+------------+-----------
s45198 | Superuser | {}

rhnschema=# grant all on schema public to s45198;
GRANT
rhnschema=# grant all on all tables in schema public to s45198;
GRANT
rhnschema=# grant all on table public.rhnpackageevr to s45198;
GRANT
rhnschema=# update rhnpackageevr set epoch = null where id = 19263;
ERROR: Permission denied: UPDATE is not allowed on rhnpackageevr

The grants I tried to add should have been unnecessary, but how can I, as a
Superuser, still be denied the ability to update a table?
--
Jay

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2017-04-24 15:13:36 Re: As superuser I still can't update a row in one table
Previous Message Scott Mead 2017-04-24 13:55:56 Re: Replicate only 1 out of 2 databases of Server A to Server B ?