Support managed database ownership

Supports managed PostgreSQL root users by checking permissions before setting site roles and revoking temporary access.