Mega Code Archive

 

Categories / MySQL / User Permission

 

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;