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 vote257 views1 answer
Google sheets problems cell not considered even
C#
0 vote265 views1 answer
Unity if object doens't exist
C#Unity
1 vote245 views1 answer
How to compare 2 date time in asp.net core 3.1
C#
0 vote248 views2 answers
C# wpf control to windw size
C#
0 vote241 views1 answer
Unity I run exe second monitor
C#
0 vote246 views2 answers
Unity slider decimal 0.01
C#
1 vote250 views1 answer
C# play wav file
C#
1 vote303 views1 answer
Unity c# check if multiple keys are pressed
C#Unity
0 vote274 views1 answer
403 forbidden error using Windows Forms
C#
-1 vote248 views1 answer
C# declaration definition
C#