Cannot delete role because it depends on "default privileges"

From: Durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cannot delete role because it depends on "default privileges"
Date: 2016-10-21 12:51:43
Message-ID: CAEcMXhk4qa5oixef4VtERo0oA6KMWAnU+TXW=vsAzwHTbaGndA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

We created a DB named DB_X, and a role ROLE_X.

We have a ROLE_MAIN.
This gave default privileges to all next objects in DB_X to ROLE_X.

Somebody dropped DB_X, and later he tried to drop ROLE_X.
But he got errors in PGAdmin.

---------------------------
pgAdmin III
---------------------------
An error has occurred:
ERROR: role "role_x" cannot be dropped because some objects depend on it
DETAIL: privileges for default privileges on new types belonging to role
role_main
privileges for default privileges on new functions belonging to role
role_main
privileges for default privileges on new sequences belonging to role
role_main
privileges for default privileges on new relations belonging to role
role_main
privileges for default privileges on new types belonging to role postgres
privileges for default privileges on new functions belonging to role
postgres
privileges for default privileges on new sequences belonging to role
postgres
privileges for default privileges on new relations belonging to role
postgres
---------------------------
OK
---------------------------

How to we remove the default privileges from role_x to we can drop it?

Thank you!

dd

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dasitha Karunajeewa 2016-10-21 13:10:47 Replication rolling back to normal.
Previous Message Kevin Grittner 2016-10-21 12:50:16 Re: out-of-order XID insertion in KnownAssignedXids