How to fix 2B000: dependent_privilege_descriptors_still_exist in PostgreSQL

-- Find table/view privileges
SELECT
    schemaname,
    tablename,
    privilege_type
FROM information_schema.table_privileges
WHERE grantee = 'role_name';

-- Find schema privileges
SELECT
    nspname AS schema_name,
    nspacl AS acl
FROM pg_namespace
WHERE nspacl::text LIKE '%role_name%';

-- Find database privileges
SELECT
    datname,
    datacl
FROM pg_database
WHERE datacl::text LIKE '%role_name%';

-- Connect to the database
\c your_database

-- Drop all privileges and owned objects
DROP OWNED BY role_name;

-- List all databases
\l

-- For each database:
\c database1
DROP OWNED BY role_name;

\c database2
DROP OWNED BY role_name;

DROP ROLE role_name;

-- Revoke table privileges
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM role_name;

-- Revoke schema usage
REVOKE USAGE ON SCHEMA public FROM role_name;

-- Revoke database privileges
REVOKE ALL PRIVILEGES ON DATABASE your_database FROM role_name;

-- Revoke sequence privileges
REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public FROM role_name;

-- Revoke function privileges
REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public FROM role_name;

DROP ROLE role_name;

-- First reassign ownership of all objects
REASSIGN OWNED BY old_role TO new_role;

-- Then drop privileges
DROP OWNED BY old_role;

-- Finally drop the role
DROP ROLE old_role;