roles

Each row represents a permission template and password policy for a user type.

Full schema

View all columns and table relationships

Status group

Yes, this table includes a statusgroup column. See Status Group for details.

Sample query

select
  t.hasaccesstoallcourses,
  t.hasmanagerinterfaceaccess,
  t.keyname,
  t.kind,
  t.name
from roles as t
limit 100