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)