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=GRANTfrom=%2Fdoc%2Fen%2Findex.html -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Subject: Setting Permission For Column Level Only Greetings... I

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 I entered

Re: Setting Permission For Column Level Only

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

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 give a