I defined a linked server from a SQL Server box to a MySQL box. I went through a very detailed set of instructions and steps, everything works like a charm when I am logged in.
The linked server definition specifies a MySQL account to access the MySQL database (all connections).
When I use my own (administrator) account to login, the links works great. I can both query the tables and view a list of tables in the remote catalog.
When I login with a read-only account, I can run queries against the link, but am unable to view a list of tables (in SSMS).
What extra permission do I need to grant to this read-only SQL login in order to get it to fully work?
Update I found a work-around:
exec sp_Tables_ex 'LinkesServername'
Works good enough.