configurations/mysql/acl_restrictions.sql

4 lines
119 B
MySQL
Raw Permalink Normal View History

SHOW GRANTS FOR 'role';
REVOKE ALL ON *.* FROM 'role'@'%';
GRANT ALL ON ex_database.* TO 'role'@'%' WITH GRANT OPTION;