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]

Reply via email to