Safely Deleting PostgreSQL Roles and Reassigning Ownership (Interactive Script)

Managing PostgreSQL roles securely is crucial, especially when decommissioning application users or consolidating database accounts. Simply dropping a role can fail if it owns objects, databases, or has privileges scattered across multiple databases....