469,903 Members | 2,126 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

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 <td******@ucdavis.edu>
To: my***@lists.mysql.com

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 JohnDoe@localhost;
ERROR 1064: You have an error in your SQL syntax near 'pass on
practicedb.Acct to JohnDoe@localhost' 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/mysql?unsub=td******@ucdavis.edu

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1388

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Chris Callahan | last post: by
reply views Thread by Tiffany Wilkes | last post: by
reply views Thread by Tiffany Wilkes | last post: by
reply views Thread by Fei Peng | last post: by
2 posts views Thread by Praveen_db2 | last post: by
1 post views Thread by jatinder.saundh | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.