RDS MySQLでテーブルにログ出力をした場合の権限付与方法(masteruser以外のアカウント)
SELECT * FROM mysql.slow_log;
SELECT * FROM mysql.general_log;
SELECT * FROM mysql.slow_log_backup;
SELECT * FROM mysql.general_log_backup;
CALL mysql.rds_rotate_slow_log;
CALL mysql.rds_rotate_general_log;
#過去データを消し去りたい場合は、2回連続で実行することで消せる
GRANT EXECUTE ON PROCEDURE mysql.rds_rotate_slow_log TO foo;
GRANT EXECUTE ON PROCEDURE mysql.rds_rotate_general_log TO foo;
GRANT SELECT ON TABLE `mysql`.`general_log_backup` TO 'foo'@'%';
GRANT SELECT ON TABLE `mysql`.`slow_log_backup` TO 'foo'@'%';
GRANT SELECT ON TABLE `mysql`.`general_log` TO 'foo'@'%';
GRANT SELECT ON TABLE `mysql`.`slow_log` TO 'foo'@'%';