CURRENT_ROLE()

语法说明

返回当前会话的角色。

语法结构

1. SELECT CURRENT_ROLE();

示例

1. mysql> select current_role();
2. +----------------+
3. | current_role() |
4. +----------------+
5. | moadmin        |
6. +----------------+
7. 1 row in set (0.00 sec)

9. -- 新建一个角色，并且切换到新角色
10. create role use_role_1;
11. grant all on database * to use_role_1;
12. grant use_role_1 to root;
13. set role use_role_1;
14. mysql> select current_role();
15. +----------------+
16. | current_role() |
17. +----------------+
18. | use_role_1     |
19. +----------------+
20. 1 row in set (0.00 sec)