Mega Code Archive

 

Categories / MySQL / User Permission

 

An example GRANT statement that assigns column-level privileges

GRANT SELECT, UPDATE (BookTitle, Copyright) ON test.Books TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1';