Get table sizes without SELECT permission
Create an EVENT that fires every 15 minutes. Here is a tutorial.

The EVENT could be used to populate a table with the necessary information.

Then GRANT SELECT on that table and only that table to your user.