MySQL 8 Administrator???s Guide

SET ROLE

SET ROLE changes the active roles within the current session. Refer to the following commands related to SET ROLE:

mysql> SET ROLE NONE; SELECT CURRENT_ROLE();+----------------+| CURRENT_ROLE() |+----------------+| NONE |+----------------+mysql> SET ROLE 'developer_read'; SELECT CURRENT_ROLE();+----------------+| CURRENT_ROLE() |+----------------+| `developer_read`@`%` |+----------------+

The first command will deactivate all roles for the user in the current session. You can see the effect with the CURRENT_ROLE(); function. In the second command, we are setting the 'developer_read' role as default, and then checking the current role using the predefined function again.