On Sunday, September 29, 2002, at 10:17 24h, Insanely Great wrote:
> 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. You have to enter data into the tables_priv table, but NOT the db table. I believe all the fields in the tables_priv table need to be filled except Table_priv. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707 Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- --------------------------------------------------------------------- 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