1 year, 10 months ago Michael Shanks

Is there a way to "SET DEFAULT ROLE ALL;"? That way whatever roles you assign to a user will be default, including multiple roles at a time and all subsequent roles that are assigned to the user like in Oracle. That would make role management MUCH easier.

1 year, 10 months ago Sergei Golubchik

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.