Add a database user

ddl.sql

-- as master user
CREATE USER 'TICKET'@'%' IDENTIFIED BY '************';
GRANT SELECT ON `prime`.`table` TO 'TICKET'@'%';
GRANT INSERT, UPDATE ON TABLE `prime`.`table` TO 'TICKET'@'%';
FLUSH PRIVILEGES;
 
-- as TICKET user
-- DO SOME DANGEROUS JOB

-- as master user
DROP USER 'TICKET'@'%';

ddl2.sql

-- @ root user session
CREATE USER 'monitoring'@'%' IDENTIFIED BY '**';
GRANT PROCESS ON *.* TO 'monitoring'@'%';
GRANT SELECT ON `performance_schema`.* TO 'monitoring'@'%';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'monitoring'@'%';

-- @ monitoring user session
SHOW FULL PROCESSLIST;
KILL /*PID*/;

-- RDS stored_procedure
CALL mysql.rds_kill(/*PID*/);