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 PM
Subject: column privilege problem--Solved
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
-->
--> I solved the problem-
Hi Tiffany,
The Grant format for the Column privilege is a bit confusing ,bit here
it goes:
GRANT (column1,column2, etc...) ON TO
<'username'@'hostname'> IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
f.e
GRANT SELECT (student_id) ON training_db.student TO
'columnuser'@'localhost' IDENTIFIE
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
