MySQL Forums
Forum List  »  Security

only allow update on a table
Posted by: Ian Porter
Date: September 27, 2010 05:27AM

Hi all,

I am only wanting to have a user to have access to update a table and not to be able to select from it, I am using the MyISAM database engine, mysql version 5.1.41 and if I grant update on the table

grant update on 'database','tablename' for 'username'@'localhost';

and if I try to do
update tablename set col = value where id = 2;

the error that comes back is

1143 SELECT command denied to user 'ianp'@'localhost' for column 'id' in table 'tablename'

any help.

http://www.codingfriends.com



Edited 1 time(s). Last edit at 09/27/2010 06:12AM by Ian Porter.

Options: ReplyQuote


Subject
Views
Written By
Posted
only allow update on a table
3089
September 27, 2010 05:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.