system.current_roles

Contains active roles of a current user. SET ROLE changes the contents of this table.

Columns:

• role_name (String)) — Role name.
• with_admin_option (UInt8) — Flag that shows whether current_role is a role with ADMIN OPTION privilege.
• is_default (UInt8) — Flag that shows whether current_role is a default role.

Original article