Hello, I want one of my MySQL-users only update one of my columns in a table. I used grant UPDATE (column1) on database1.table1 to 'user1'@'localhost' but the user1 can update other culumns too.
The mysql-db-table entries for user1 after grant command are: - db: - - host: - - user: Select_priv: Y - tables_priv: Table_name: table1; Table_priv: - ; Column_priv: Update - columns_priv: Table_name: table1; Column_name: column1; Column_priv: Update What can I do? I use MySQL 4.0.3-beta-nt on Windows 2000 Server with PHP 4.2.2 and phpMyAdmin 2.3.2. Wolfgang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]