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 vote181 views1 answer
Apt install sql server
SQL
2 votes133 views5 answers
Alter table primary key postgresql
SQL
0 vote161 views1 answer
Get sum sqlite android
SQL
0 vote196 views1 answer
How to see the query of a view in mysql
SQL
1 vote195 views1 answer
UseSqlServer no definition
SQL
2 votes184 views5 answers
Eloquest how to select one specific column in database
SQL
1 vote185 views1 answer
How to truncate a table in databse
SQL
0 vote158 views1 answer
Alter boolean column postgresql
SQL
0 vote176 views1 answer
Pl/ sql change currency
SQL
13 votes167 views2 answers
Oracle select into and inner join
SQL