I am just a user (not an administrator) and would like to know what privileges I have with my MySQL user account. Is there a SELECT command I can construct that will list these privileges?
Yes, SHOW GRANTS:
http://www.mysql.com/doc/en/SHOW_GRANTS.html
Issue a SELECT CURRENT_USER() statement to find out what your account is, then use the value with SHOW GRANTS:
mysql> SELECT CURRENT_USER(); +----------------+ | CURRENT_USER() | +----------------+ | [EMAIL PROTECTED] | +----------------+ 1 row in set (0.07 sec)
mysql> SHOW GRANTS FOR 'paul'@'localhost';
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
