dbconsole: database page fails to load for non-admin users

[knz]

I created a non-admin user and granted it VIEWACTIVITY but not the admin role.

When navigating to the db list I see the following:

Expected behavior

A non-privileged user should be able to see the db list with just the DBs they have access to.

Jira issue: CRDB-28004

[knz]

This is v23.1 by the way.

cc @kevin-v-ngo @j82w for triage.

[knz]

Note: this used to work for v22.1. So marking as regression.

[maryliag]

another error also being displayed (Serverless):
Error Loading databases: Error: Error while retrieving database details information: only users with the ZONECONFIG privilege or the admin role can read crdb_internal.ranges_no_leases

[knz]

started a thread here: https://cockroachlabs.slack.com/archives/C0159JK877C/p1689090652345839

[knz]

It's unclear why the serverless error only mentions ZONECONFIG, whereas in the code it also mentions VIEWACTIVITY.

Maybe this test was using an older version of crdb under the hood?

[THardy98]

Below are PRs that allow users with restricted permissions to still view the databases pages:

Databases Page Improvement: #109245
Database Detail Page Improvement: #109432
Table Detail Page Improvement (database table page - specifically relevant to this issue): #109521

[THardy98]

Closing the issue per the PRs listed above