Creative SQL: How to Easily SHOW GRANTS for Many Users

Posted September 13th, 2008 by sheeri

Scenario: Someone wants to know which of the over 50 MySQL users have certain privileges.

There are many ways to solve this problem. Some of these scenarios are tedious and repetitious, others take no time at all.

The issue, of course, lies in what the "certain" privileges are. If ...

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Comment: *

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
Lines and paragraphs break automatically.
You may use <swf file="song.mp3"> to display Flash files inline
Avast! This website be taken over by pirates on September 19th. Yarr!
Each email address will be obfuscated in a human readable fashion and replaced with a spamproof clickable link, without loosing the mailto URL scheme semantics and operations.
You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

Email me about all replies to this article.

Captcha

This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Math Question: * 9 + 10 =

Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.