Found while investigating #110001.

Describe the problem

When TestNodeStatusResponse in server/storage_api is modified to point to a secondary tenant (e.g. via #110008), the test starts failing when accessing the /_status/nodes endpoint:

    nodes_test.go:113: expected privilege error, got status: 501 Not Implemented, content-type: application/json, body: {
          "error": "method Nodes not implemented",
          "code": 12,
          "message": "method Nodes not implemented",
          "details": [
          ]
        }, error: <nil>

How to reproduce

from #110008 reset DefaultTestTenant in TestNodeStatusResponse, run the test with a test tenant and observe the failure.

Expected behavior

Once the tenant is granted a suitable capability, the endpoint should work properly. It should retrieve the node details over the KV tenant connector over the network.

Epic CRDB-38968

Jira issue: CRDB-31228