Hello.
I can see such behavior in test database because mysql.db table has records which allows updates to any user, and database privileges ORs with global privileges. Send us the contents of your privileged tables. See: http://dev.mysql.com/doc/mysql/en/request-access.html Upgrade to the latest release 4.1.12 (4.0.24). "Wolfgang Gliese" <[EMAIL PROTECTED]> wrote: > 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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
