targetmysql.sql

GRANT CREATE ON *.* TO 'dbadmin';
GRANT ALTER ON *.* TO 'dbadmin';
GRANT DROP ON *.* TO 'dbadmin';
GRANT INDEX ON *.* TO 'dbadmin';
GRANT REFERENCES ON *.* TO 'dbadmin';
GRANT SELECT ON *.* TO 'dbadmin';
GRANT CREATE VIEW ON *.* TO 'dbadmin';
GRANT SHOW VIEW ON *.* TO 'dbadmin';
GRANT TRIGGER ON *.* TO 'dbadmin';
GRANT CREATE ROUTINE ON *.* TO 'dbadmin';
GRANT ALTER ROUTINE ON *.* TO 'dbadmin';
GRANT EXECUTE ON *.* TO 'dbadmin';
-- only for MySQL <8.0 GRANT SELECT ON mysql.proc TO 'awssct';
GRANT INSERT, UPDATE ON AWS_SQLSERVER_EXT.* TO 'dbadmin';
GRANT INSERT, UPDATE, DELETE ON AWS_SQLSERVER_EXT_DATA.* TO 'dbadmin';
GRANT CREATE TEMPORARY TABLES ON AWS_SQLSERVER_EXT_DATA.* TO 'dbadmin';
GRANT CREATE TEMPORARY TABLES ON *.* TO 'dbadmin';
-- MySQL <8 code GRANT INVOKE LAMBDA ON *.* TO 'awssct';
GRANT AWS_LAMBDA_ACCESS TO 'dbadmin'; 
GRANT INSERT, UPDATE ON AWS_ORACLE_EXT.* TO 'dbadmin';
GRANT INSERT, UPDATE, DELETE ON AWS_ORACLE_EXT_DATA.* TO 'dbadmin';
grant INSERT ON aws_sqlserver_ext.* to 'dbadmin';
grant UPDATE ON aws_sqlserver_ext.* to 'dbadmin';