Grant select and update on two column in a table : SQL Privilege « User Permission « SQL / MySQL






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;


           
       








Related examples in the same category

1.Check the privilege
2.Grant with user name and password
3.Grant select and update to all tables
4.Grant select and update with time limitation
5.Check out the privilege for a user
6.List the host, DB, table name and column name for a user
7.Adding Users to Database
8.Read the user table
9.Read host, db, user, table name and table privilege from privilege table
10.Read column privilege