User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. An example GRANT statement that assigns column-level privileges
GRANT SELECT, UPDATE (BookTitle, Copyright)
ON test.Books
TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1';