Here the contents of my privileged tables: mysql.db table for dtk10mv after GRANT UPDATE (status_dtk10) on tim.tk25no_meld to 'dtk10mv'@'localhost': - db: - - host: - - user: Select_priv: Y - tables_priv: Table_name: tk25no_meld; Table_priv: - ; Column_priv: Update - columns_priv: Table_name: tk25no_meld; Column_name: status_dtk10; Column_priv: Update
mysql.db table for dtk25mv after GRANT UPDATE (status_dtk25) on tim.tk25no_meld to 'dtk25mv'@'localhost': - db: - - host: - - user: Select_priv: Y - tables_priv: Table_name: tk25no_meld; Table_priv: - ; Column_priv: Update - columns_priv: Table_name: tk25no_meld; Column_name: status_dtk25; Column_priv: Update CREATE TABLE tk25no_meld ( tk25no_meld_id int(6) NOT NULL auto_increment, timestamp timestamp(12) NOT NULL, lfdnr int(4) NOT NULL default '0', unternr int(2) NOT NULL default '1', status_dtk10 char(1) NOT NULL default 'N', status_dtk25 char(1) NOT NULL default 'N', PRIMARY KEY (tk25no_meld_id) ) TYPE=MyISAM; INSERT INTO tk25no_meld VALUES (1, 050418093109, 1, 1, 'N', 'N'); INSERT INTO tk25no_meld VALUES (2, 050520110021, 2, 1, 'J', 'J'); User dtk25mv can update column status_dtk10 and I donīt know why. http://dev.mysql.com/doc/mysql/en/request-access.html didnīt help. I will try new MySQL release 4.1.12 and then I tell You. Regards, Wolfgang 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
