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]