Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make a table readonly?

Status
Not open for further replies.

kknight2046

Programmer
Jul 6, 2006
17
US
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.
 
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top