[talk] Databases

N.J. Thomas njt at ayvali.org
Sun Oct 16 22:27:17 EDT 2016


* Sujit K M <kmsujit at gmail.com> [2016-10-15 18:42:05+0530]:
> I was recently looking at databases or infact user who are readonly. I
> wanted to know whether MySQL on FreeBSD happens to have a write
> configuration which lets you disable the write part totally.

If I understood you correctly, I think what you want is to create a user
and grant them only read permissions. Here's the syntax for the GRANT
command:

    http://dev.mysql.com/doc/refman/5.7/en/grant.html

You can do this at the database or table level.

Thomas



More information about the talk mailing list