RE: Setting Permission For Column Level Only

2002-09-30 Thread Luc Foisy
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 >

Re: Setting Permission For Column Level Only

2002-09-29 Thread Clayburn W. Juniel, III
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 giv

Re: Setting Permission For Column Level Only

2002-09-29 Thread Insanely Great
, 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 cre

Re: Setting Permission For Column Level Only

2002-09-29 Thread Clayburn W. Juniel, III
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

Setting Permission For Column Level Only

2002-09-29 Thread Insanely Great
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