INFORMATION_SCHEMA.* privileges

[Rubén Laguna]

I'm have been tasked with adding some MySQL databases to a data catalog (OpenMetadata), it seems that from the documentation of OM the user that OM uses will require SELECT on all tables because otherwise the INFORMATION_SHEMA.* won't show anything (it only shows objects for which the current user / roles already has access privileges on).

And I wonder, is that the only alternative to get the tables / columns, metadata in general, etc ?

Obviously giving SELECT on everything to OM it's a huge security risk because if OM is compromised then all the data can be exposed (data leak).

So it's there any alternative to get metadata (tables names, columns, etc) with a user with minimal permissions?

The databases in question are Google Cloud SQL using InnoDB storage engine as far as I know (I'm not the admin of those)