Roles.Example1.sql

-- Grants access to all databases and tables to the role "dba"
GRANT ALL ON *.* TO 'dba';

-- Grants access to the database "app" to the role "readonly"
GRANT SELECT ON app.* TO 'readonly';

-- Grants access to the database "app" to the role "datawrite"
GRANT INSERT, UPDATE, DELETE ON app.* TO 'app_write';

-- Grants access to developers
GRANT ALTER, DELETE, INDEX, INSERT, SELECT, UPDATE, CREATE VIEW,
SHOW VIEW, TRIGGER, CREATE TEMPORARY TABLES ON app.* TO 'developer';