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
