Skip to main content
Skip to main content
Edit this page

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.
Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free