Show Grants, is there an easier method?

[George Vieira]

I'm just starting on the .NET connector and it works well but what I would like to do is allow the program I'm creating to know what fields the user who connects to the database has access to, whether it's select only or update or insert as well..

I tried doing SHOW GRANTS FOR {username} but the info that returns is different between users.

One user may return :

GRANT SELECT (id, name, number, jobnumber), UPDATE (number) ON `testdb`.`clients` TO 'admin'@'%'

Another may show just this :

GRANT SELECT ON `servicecentre`.`parts` TO 'sc-booking'@'%'

So I tried to enumerate the data returned into a collection of some sort so you can query it with something as simple as :

mysql.grants("testdb.clients.name")

and it will return some like "select,insert,update" etc.etc.. which is working but I'm still getting changes from time to time which my routine doesn't catch the returned SHOW GRANTS data and causes exceptions... I GIVE UP..


I can't find any commands to find what is granted to the user easily.. Is there a dumb a__ easier way?

tell my i wasted my time.. :P