CURRENT_ROLE_NAME()

Description

CURRENT_ROLE_NAME() is used to query the name of the role owned by the user you are currently logged in.

Syntax

  1. > CURRENT_ROLE_NAME()

Examples

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