GRANT CREATE VIEW
ON company_security.*
TO user1 IDENTIFIED BY 'password1';
Query OK, 0 rows affected, 1 warning (0.02 sec)

SHOW GRANTS FOR user1;

+----------------------------------------------------------------------+
| Grants for user1@%                                                   |
+----------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user1'@'%'                                    |
| GRANT CREATE VIEW ON `company_security`.* TO 'user1'@'%'             |
| GRANT SELECT, INSERT ON `company_security`.`employee` TO 'user1'@'%' |
+----------------------------------------------------------------------+