Read only table in mysql
I'm using mysql database. In that I have table called tbl_user I need to change this as read only table to every user. How to change the table as read only ?
To grant all user select, use public instead of a complete user list
REVOKE ALL ON tbl_user FROM PUBLIC GRANT SELECT ON tbl_user TO PUBLIC
Use the REVOKEcommand and revoke INSERT / UPDATE / DELETE rights from that table for the user
REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] priv_level FROM user [, user] ...