sql: SHOW GRANTS ON TYPE does not work for types not in the current database

[RichardJCai]

SHOW GRANTS ON TYPE will only show grants if the type is in the current database.
Specifying a type in another database does not work.

[email protected]:26257/movr> create database test;
CREATE DATABASE


Time: 3ms total (execution 3ms / network 0ms)

[email protected]:26257/movr> create type test.typ as enum();
CREATE TYPE


Time: 4ms total (execution 4ms / network 0ms)

[email protected]:26257/movr> create user testuser;
CREATE ROLE


Time: 28ms total (execution 28ms / network 0ms)

[email protected]:26257/movr> grant all on type test.typ to testuser;
length: 1
GRANT


Time: 26ms total (execution 26ms / network 0ms)


[email protected]:26257/movr> show grants on type test.typ;
  database_name | schema_name | type_name | grantee | privilege_type
----------------+-------------+-----------+---------+-----------------
(0 rows)


Time: 14ms total (execution 14ms / network 0ms)

Epic CRDB-7217