I'm glad that worked for you the manual should be updated with clearer
examples..
-Martin
Allan Bakke was right!
- Original Message -
From: "Tiffany Wilkes" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, August 05, 2003 3:48
FYI
Note on this. Using column privs you take a performance penalty on reads
/ writes.
-->-Original Message-
-->From: Tiffany Wilkes [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, August 05, 2003 3:48 PM
-->To: mysql
-->Subject: column privilege problem--Solved
-->
-->
Wilkes [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, August 05, 2003 3:48 PM
-->To: mysql
-->Subject: column privilege problem--Solved
-->
--> I solved the problem--I needed ( ) around the column list. I think
-->the manual should make that more clear.
-->
--> Origina
Hi,
I am having problems granting column privileges. I want to grant the
update privilege (only) to a column (called pass) in a table (called
Acct). Here's what I get:
mysql> grant update pass on practicedb.Acct to [EMAIL PROTECTED];
ERROR 1064: You have an error in your SQL syntax near 'pass
Tiffany Wilkes <[EMAIL PROTECTED]> wrote:
>
> I am having problems granting column privileges. I want to grant the
> update privilege (only) to a column (called pass) in a table (called
> Acct). Here's what I get:
>
> mysql> grant update pass on practicedb.Acct to [EMAIL PROTECTED];
> ERROR 1
I solved the problem--I needed ( ) around the column list. I think
the manual should make that more clear.
Original Message
Subject: column privilege problem
Date: Tue, 05 Aug 2003 15:39:54 -0700
From: Tiffany Wilkes <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Hi,
