User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. Grant select and update on two column in a table
/* BookTitle and Copyright are field names */
GRANT SELECT, UPDATE (BookTitle, Copyright)
ON databaseName.tableName
TO 'usrName'@'domain1.com' IDENTIFIED BY 'password'
REQUIRE SSL;