> How can I revoke a GRANT OPTION on a database or table from a user? > > The manual <http://dev.mysql.com/doc/refman/5.0/en/grant.html> says > something about > > REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... > > but this can only revoke the GRANT OPTION on a global level as it seems, > not on a certain database or table. Trying to use this query > > REVOKE ALL PRIVILEGES, GRANT OPTION ON `test`.* FROM 'test'@'localhost' > > fails with the error message > > You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'ON `test`.* FROM 'test'@'localhost'' at line 1
It works as two separate queries: REVOKE ALL PRIVILEGES ON `test`.* FROM 'test'@'localhost'; REVOKE GRANT OPTION ON `test`.* FROM 'test'@'localhost'; -- Dan Fulbright -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
