You know that process would be much easier if you used the GRANT syntax http://www.mysql.com/doc/search.php?q=GRANT&from=%2Fdoc%2Fen%2Findex.html
> -----Original Message----- > From: Insanely Great [mailto:[EMAIL PROTECTED]] > Subject: Setting Permission For Column Level Only > > > Greetings... > > I want to create a user which will have only Select privileges in two > columns a particular table. > > For that I creates a entry in the User table in MySQL and set > it as default > with N in all. > > Also I entered some rows in the Columns_Priv table. Now my > question is - > > Do I have to enter records in db and tables_priv table with > the user name > and all privileges set to N or default to make the column > privileges work or > if I enter a row in the columns_priv table, that will do. > > Rgds > Insane > --------------------------------------------------------------------- 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