Can you connect as user postgres? IE: psql -U postgres -d <yourdb>
If so, then you should have the ability to execute the commands without any problem.On Wed, Oct 7, 2015 at 9:53 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 10/07/2015 05:12 AM, Andrus wrote:
Hi!
The objects can't be owned by nothing, so you will need to reassign
ownership:
REASSIGN OWNED BY old_role TO new_role;
e.g.
REASSIGN OWNED BY vantaa TO postgres;
Then you can drop the role.
User who deletes other users is not superuser. It is created using
CREATE ROLE admin LOGIN
NOSUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION CONNECTION LIMIT
100;
GRANT idd_owner TO admin;
I tried
So to be clear admin is doing the below, correct?
REASSIGN OWNED BY vantaa TO postgres;
and
REASSIGN OWNED BY vantaa TO idd_owner;
but got error
permission denied to reassign objects .
Is the above a blanket error or does it mention specific objects?
How to fix ?
What you are trying to do is reverse what you did to get the present setup. Do you have a record/script that shows what you did to create the role and assign it to the objects?
I can add some rights to user who invokes this command if this helps.
Andrus.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
