Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.