Durumdara <durumdara@xxxxxxxxx> writes: > 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. > 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 See DROP OWNED BY. https://www.postgresql.org/docs/9.6/static/role-removal.html regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
