sql-DCL

-- user 조회,생성
select user, host from mysql.`user` u;
create user 'my_app'@'%' identified by 'my_password';

-- 권한 부여
-- *특정 권한만 부여가능, *특정DB에만 권한 부여 가능   

GRANT ALL PRIVILEGES ON 데이터베이스명.* TO '계정아이디'@'호스트';
GRANT ALL PRIVILEGES ON *.* TO '계정아이디'@'호스트';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD ON *.* TO '계정아이디'@'호스트';  
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, LOAD FROM S3, SELECT INTO S3, INVOKE LAMBDA, INVOKE SAGEMAKER, INVOKE COMPREHEND ON *.* TO 'my_app'@'%';

-- 권한 갱신
FLUSH PRIVILEGES; 

-- 권한 조회 
SHOW GRANTS FOR 'my_app'@'%';