activate_all_roles_on_login configuration

This feature, available from mysql 8.0.x, would be extremely useful to control permissions for a user via a union of roles. Currently, when many roles are granted to a user, client side code needs to be modified to select different roles, for the right role to be assigned each this. This requires code aware of roles on client side, and makes it near impossible to share connections on the same db server, with different permissions per database or tables.

Supporting this configuration, will grant all roles to a user upon login , not only the default role and will make things a lot easier for when users need to be granted with a union of roles.

I am hoping this should be a simple addition on server side code.

Thanks