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--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,
-->
-->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 on
-->practicedb.Acct to [EMAIL PROTECTED]' at line 1
-->
-->I don't understand how the syntax is wrong.  I think I followed the
-->instructions in the manual.  I don't have any problems granting table
-->privileges--just column.
-->
-->Tiffany Landry
-->
-->
-->--
-->MySQL General Mailing List
-->For list archives: http://lists.mysql.com/mysql
-->To unsubscribe:
-->http://lists.mysql.com/[EMAIL PROTECTED]
-->
-->
-->
-->
-->
-->--
-->MySQL General Mailing List
-->For list archives: http://lists.mysql.com/mysql
-->To unsubscribe:
-->http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to