Comments - SET DEFAULT ROLE
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
No and SQL Standard does not allow to SET more than one role.
A workaround for you would be to create a role, say, "my_default_role", make it default, and grant all other roles not to you directly, but to this role. It'll work exactly as you want — all roles assigned to "my_default_role" will be immediately available to you.