Thank you! That is what I was looking for! Unfortunatly that command is not SQL 92 or SQL 99 standard, isn't it? (at least I guess, after I quick search in my ANSI files...., BTW I think if they had put in MySQL documentation a note for each SQL command where is specified standard compliance that would be greatly appreciated!)
Since for the rest my application was standard SQL92... it's a pity bye Plinio On Mon, 22 Dec 2003 15:37:43 +0200 Egor Egorov <[EMAIL PROTECTED]> wrote: > Plinio Conti <[EMAIL PROTECTED]> wrote: > > > > Is there a way to query the privileges of current user if he hasn't the rights to > > read the mysql system tables (user, db, hosts, etc..) > > > > I mean, I CAN'T give a standard user the chance of read "system tables"! > > But my client app wants to know if the current user has (for example) the rights > > to write on table xxx, because if not, I don't want to let him try and fail, I > > want to disable the updates in advance. > > > > Take a look at SHOW GRANTS command: > http://www.mysql.com/doc/en/SHOW_GRANTS.html > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]