Show System Grants Errors - User Lacks SELECT Privilege on 'privileges' Relation #104412
Description
Describe the problem
Despite our doc stating that no privileges are required to execute "show system grants", the command isn't functioning as expected when "show system grants" for the logged in user is executed.
fbtcrdbadmin@34.82.243.36:26257/defaultdb> show system grants for fbtcrdbadmin;
ERROR: user fbtcrdbadmin does not have SELECT privilege on relation privileges
SQLSTATE: 42501
fbtcrdbadmin@34.82.243.36:26257/defaultdb> show system grants;
ERROR: user fbtcrdbadmin does not have SELECT privilege on relation privileges
SQLSTATE: 42501
fbtcrdbadmin@34.82.243.36:26257/defaultdb>
Environment:
CockroachDB version 23.1.1
Jira issue: CRDB-28517
Epic CRDB-27601