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