Does anyone know if GRANT statements can be issued with a stored procedure in MySQL 5.0a?
Also, can anyone point me to the correct syntax to INSERT INTO the columns_priv table? I'm not sure how to insert multiple values into the column_priv field. This is what I have tried:
INSERT INTO columns_priv (host, user, db, table_name, column_name, column_priv) VALUES('%', 'test2', 'pcr', 'pcr_td_data', 'state', 'SELECT' + 'INSERT');
Thanks,
Animaul