i am having trouble creating table grants, and column-specific ones (cannot do it from cpanel). would it be a security issue if i ask my hosting provider to allow my mysql primary user to give grants to the other db users?

or can i do it by doing a full backup, changing mysql.sql from the tar.gz created, reuploading it to the server and reverting to that?

(ex: not allowing user to change username, allowing admin to change user's username but not view password etc)

sample query:
GRANT SELECT, INSERT (col1, col2, col4, col7, col11, col19) ON `database`.`table` TO 'user'@'host'