Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
I would not have added the mysql tag, because the issue is not at the mysql end. The same login is being used (as defined in the linked server definition) regardless of what SQL Server account is currently logged in. –  datagod Oct 18 '12 at 20:03

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.