To be honest, the fact I can't get it with only one query but I have to do:

1) SELECT CURRENT_USER();

2) SHOW GRANTS FOR valueExtractedByPreviousQuery;

is a little thing compared with work remaing to get usefull information:
I have to parse the strings returned by query 2, handle the wildcards, handle "ALL 
PRIVILEGES", comparing db-level privileges with table-level ones and with column-level 
ones, etc...

I probably will do all that, only I wonder there is not a more simple solution.

I mean, it looks a so common issue that I imagine there is better solution but I can't 
figure which.

User authenticates, and client app wants to know what that user is allowed to do, so 
the app can show to its user the correct user interface (for example editing disabled 
if user can't write, etc..)




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to