system.enabled_roles

System table containing all active roles at the moment, including the current role of the current user and the granted roles for the current role

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.