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