See www.zabbix.com for the official Zabbix site.

Docs/DB schema/3.4/usrgrp

From Zabbix.org
Jump to: navigation, search

This table contains user groups.

Columns

Column Detail Default NULL? Type Ref from Ref to
usrgrpid User group ID. Managed by Zabbix via the ids table. NONE NOT NULL id config.alert_usrgrpid
dashboard_usrgrp.usrgrpid C
opmessage_grp.usrgrpid
rights.groupid C
screen_usrgrp.usrgrpid C
scripts.usrgrpid
slideshow_usrgrp.usrgrpid C
sysmap_usrgrp.usrgrpid C
users_groups.usrgrpid C
name User group name. EMPTY NOT NULL varchar(64)
gui_access Zabbix frontend access for users who are in this group.
  • 0 - GROUP_GUI_ACCESS_SYSTEM - use the default authentication mechanism
  • 1 - GROUP_GUI_ACCESS_INTERNAL - use the internal authentication
  • 2 - GROUP_GUI_ACCESS_DISABLED - no access to the frontend
0 NOT NULL integer
users_status Status for users who are in this group.
  • 0 - GROUP_STATUS_ENABLED
  • 1 - GROUP_STATUS_DISABLED
0 NOT NULL integer
debug_mode Frontend debug mode for users in this group.
  • 0 - GROUP_DEBUG_MODE_DISABLED
  • 1 - GROUP_DEBUG_MODE_ENABLED
0 NOT NULL integer

Indexes

Name UNIQ Columns
PRIMARY KEY YES usrgrpid
usrgrp_1 YES name