I don't have an answer for you, just a question out of curiosity. Is this a prelude to dropping the role? Thus, if it existed,DROP ROLE ... CASCADE would have worked for your use case? (Even so, I could still see other uses for your request.)
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных