Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

system.enabled_roles

View as MarkdownEdit this pageReport an issueSet up docs MCP

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.
Navigation