Skip to main content

​
Description

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) — 1 if the role has ADMIN OPTION privilege.
  • is_default (UInt8) — 1 if role is set to be a default.
Last modified on July 3, 2026