Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'd like a monitor user be able to (only) execute "SHOW INDEX" and "SHOW TABLES" on a certain database. What privileges should I GRANT this user?

I'd rather not open up for the user to be able to do SELECTs...

share|improve this question
up vote 0 down vote accepted

I believe SELECT is necessary for both of these commands. I suspect the only way to be absolutely certain is to test this performance.

Arthur Ogawa's comment reinforces my suspicion.

share|improve this answer
SELECT worked for me. Thanks. – Ztyx Apr 10 '10 at 10:14

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.