Thx.... Well I have one more question....
What is the exact GRANT SQL statement for giving column level privilege. Whatever text I have read till now allow me to give table level privilege. I am unable to give a column level privilege. I have a db......product with tables prod_user and prod_detials....prod_user has three columns id, name, address. I want to give a user permission for select only on id, name and not on address ? Any ideas ? Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL ----- Original Message ----- From: "Clayburn W. Juniel, III" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 30, 2002 7:00 AM Subject: Re: Setting Permission For Column Level Only > > 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 > --------------------------------------------------------------------- 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