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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
