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

1 vote361 views1 answer
How to disable click listener in android
C#
0 vote335 views1 answer
SortDescriptions wpf
C#
4 votes338 views2 answers
Group by linq multiple columns C#
C#
6 votes329 views2 answers
C# remove character from string at index
C#
1 vote337 views2 answers
C# structure
C#
0 vote340 views1 answer
Windows form Webbrowser url detection
C#
2 votes358 views1 answer
C# convert dictionary to anonymous object
C#
5 votes356 views2 answers
C# check number is odd or even
C#
0 vote396 views1 answer
Reflection assemblies gettypes
C#
0 vote327 views1 answer
How to backup terrain in unity
C#