-------------------------------+ | SELECT (column_list) | Read values in columns using the | | | SELECT statement. You cannot access or | | | query any columns for which you do not | | | have SELECT privileges, including in | | | WHERE, ON, GROUP BY, and ORDER BY | | | clauses. | +----------------------------------+-----------------------------------------+ | UPDATE (column_list) | Update values in columns of existing | | | rows using the UPDATE statement. | | | UPDATE statements usually include a | | | WHERE clause to update only certain | | | rows. You must have SELECT privileges | | | on the table or the appropriate | | | columns for the WHERE clause. | +----------------------------------+-----------------------------------------+ Function Privileges ------------------- +----------------------------------+-----------------------------------------+ | Privilege | Description | +----------------------------------+-----------------------------------------+ | ALTER ROUTINE | Change the characteristics of a stored | | | function using the ALTER FUNCTION | | | statement. | +----------------------------------+-----------------------------------------+ | EXECUTE | Use a stored function. You need SELECT | | | privileges for any tables or columns | | | accessed by the function. | +----------------------------------+-----------------------------------------+ | GRANT OPTION | Grant function privileges. You can | | | only grant privileges that you have. | +----------------------------------+-----------------------------------------+ Procedure Privileges -------------------- +----------------------------------+-----------------------------------------+ | Privilege | Description | +----------------------------------+-----------------------------------------+ | ALTER ROUTINE | Change the characteristics of a stored | | | procedure using the ALTER PROCEDURE | | | statement. | +----------------------------------+-----------------------------------------+ | EXECUTE | Execute a stored procedure using the | | | CALL statement. The privilege to call | | | a procedure may allow you to perform | | | actions you wouldn't otherwise be able | | | to do, such as insert rows into a | | | table. | +----------------------------------+-----------------------------------------+ | GRANT OPTION | Grant procedure privileges. You can | | | only grant privileges that you have. | +----------------------------------+-----------------------------------------+ GRANT EXECUTE ON PROCEDURE mysql.create_db TO maintainer; Proxy Privileges ---------------- +----------------------------------+-----------------------------------------+ | Privilege | Description | +----------------------------------+-----------------------------------------+ | PROXYוĹ