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 ?

Answers


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] ...

Refer Documentation


Need Your Help

Java coding for arrays

java arrays

I have to create an array whose data is input while executing, and to show the highest value and its frequency. Also the frequencies of all the other values input.My code is correct up to the part ...

How to reload a div from a form inside itself?

php ajax forms html reload

I am working on a webpage where I have a main landing-page that has a div that loads different pages; I did this so the entire page doesn't reload but ajax just sends out a call to load a different...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.