How to make a table readonly?

[kknight2046]

There are 100 tables in a database, named 'db'. I want to make one table called 'a' readonly to a user 'tom'. How can I make it happen?
Previously, I used grant command to assign ALL privilege to the user:
grant ALL on *.* to tom@%

Thanks.

 

[cLFlaVA]

you will need to grant select privilege only to the specified user.



*cLFlaVA
----------------------------
[tt]( <P> <B>)[sup]13[/sup] * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[kknight2046]

But, I still want the user have the write privileges on the other 99 tables. I only revoke the write privileges on the table 'a' for the user.
To address this problem, is it a right way that I grant a select privilege on the table 'a' for the user?

 

[cLFlaVA]

yes. grant select for the specific user to the specific table.



*cLFlaVA
----------------------------
[tt]( <P> <B>)[sup]13[/sup] * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]