I tried the SHOW GRANTS statement SHOW GRANTS FOR 'dtk10mv'@ 'localhost' and got this:
Grants for [EMAIL PROTECTED] GRANT SELECT, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'user1'@'localhost' IDENTIFIED BY PASSWORD '08862e71234184bc' GRANT UPDATE (column1) ON database1.table1 TO 'user1'@'localhost' GRANT UPDATE (column1) ON database1.table1 TO 'user1'@'localhost' There is no permission to update column2, but the user can do so. What can I do? I use MySQL 4.0.3-beta-nt. Perhaps this version is too old? (In http://dev.mysql.com/doc/mysql/en/show-grants.html there is an evidence.) To the answer from Jigal: When I delete Column_priv: update in tables_priv the user1 canīt update any column in the table. There is no exact explanation in documentation (http://dev.mysql.com/doc/mysql/en/grant.html). Regards, Wolfgang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
