Hello.
Use SHOW GRANTS statement to see all permissions which user has and revoke unnecessary. See: http://dev.mysql.com/doc/mysql/en/show-grants.html http://dev.mysql.com/doc/mysql/en/grant.html "Wolfgang Gliese" <[EMAIL PROTECTED]> wrote: > 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 > > -- 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]
