On Mon, 11 Jun 2007, Mahmoud Badreddine wrote:

> Hello,
> I am trying to revoke all privileges from a user on a certain table in a
> database.
> I want the user to continue to have all his/her privileges intact for the
> other tables though.
>
> I used the statement "REVOKE ALL PRIVILEGES on dbName.tableName from
> thisUser";
>
> But that doesn't seem to change anything.
> The message always gives "Query 0K, 0 rows affected..."
> What could I be missing.

I seem to remember that this always says 0 rows affected.
To make sure the privilege changes stick, follow that up with:

mysql> FLUSH PRIVILEGES;

That should do the trick.

Gordan