Skip to main content
Skip to main content
Edit this page

system.enabled_roles

Description

Contains all active roles at the moment, including the current role of the current user and granted roles for the current role.

Columns

  • role_name (String) — Role name.
  • with_admin_option (UInt8) — 1 if the role has ADMIN OPTION privilege.
  • is_current (UInt8) — Flag that shows whether enabled_role is a current role of a current user.
  • is_default (UInt8) — Flag that shows whether enabled_role is a default role.