RE: Setting Permission For Column Level Only
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
Re: Setting Permission For Column Level Only
On Sunday, September 29, 2002, at 09:21 24h, Insanely Great wrote: > 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. Grant Select (colum_name1), Select (Column_name2) on database_name.table_name to whoever@"%" identified by 'password' -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (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
Re: Setting Permission For Column Level Only
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_detialsprod_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-7707Mobile: (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
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-7707Mobile: (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