How to find all role in mysql

Copied CREATE USER 'dev1'@'localhost' IDENTIFIED BY 'dev1pass';
CREATE USER 'read_user1'@'localhost' IDENTIFIED BY 'read_user1pass';
CREATE USER 'read_user2'@'localhost' IDENTIFIED BY 'read_user2pass';
CREATE USER 'rw_user1'@'localhost' IDENTIFIED BY 'rw_user1pass';

Source: dev.mysql.com

How to find all role in mysql

Press CTRL+C to copy GRANT 'app_developer' TO 'dev1'@'localhost';
GRANT 'app_read' TO 'read_user1'@'localhost', 'read_user2'@'localhost';
GRANT 'app_read', 'app_write' TO 'rw_user1'@'localhost';

Source: dev.mysql.com

How to find all role in mysql

Press CTRL+C to copy GRANT ALL ON app_db.* TO 'app_developer';
GRANT SELECT ON app_db.* TO 'app_read';
GRANT INSERT, UPDATE, DELETE ON app_db.* TO 'app_write';

Source: dev.mysql.com

Similar codes

0 vote166 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote202 views1 answer
Count column of tables psql
SQL
0 vote176 views1 answer
How to get nth number in sql
SQL
0 vote167 views1 answer
Create sql table from script inline primary key constraint
SQL
-2 votes211 views1 answer
Mysql not empty
SQL
0 vote175 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote160 views1 answer
Sql developer connect to sql server
SQL
1 vote172 views2 answers
Drop table if exists test
SQL
3 votes229 views2 answers
Oracle sql first day of month
SQL
0 vote147 views1 answer
Excute raw query
SQL