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
REASSIGN OWNED BY vantaa TO postgres;
and
REASSIGN OWNED BY vantaa TO idd_owner;
but got error
permission denied to reassign objects .
How to fix ?
I can add some rights to user who invokes this command if this helps.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
