Is your feature request related to a problem? Please describe.
It'd be valuable in logic tests which exercise some secondary tenant functionality to be able to switch to the system tenant in order to adjust some system tenant controlled property and then switch back to the secondary tenant. Today we allow switching connections via the user directive.

Describe the solution you'd like

Perhaps, some extension of the user directive to indicate the tenant.

Jira issue: CRDB-14839