> Hi All, <cut>
> Now, I want to give to 'dbuser' privileges to read ONLY 'name' and > 'address' columns from table 'TBL1'. > So, I added record to mysql.user table (with no global privileges) - > thans to thar 'dbuser' is able to connect to MySQL server, and it > works OK. Further I added records to mysql.column_privileges: <cut> > My question is: > Is there anybody who can tell me what I am doing wrong, or how can I > give privileges to read only several columns from table? <cut s'more> Don't mess around with the privilege tables. Use the GRANT and REVOKE commands instead. You might also want to read http://www.bitbybit.dk/mysqlfaq/faq.html#ch11_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
