Users, Roles, and Permissions

SYSADMIN.Roles

This table supplies information on roles.

Column Name	Type	Description
`id`	biginteger	Role ID
`name`	string	Role name
`allowCreateTempTables`	boolean	Parameter indicating if it is possible to create temporary tables with this role
`users`	string	Usernames in this role

Parameter allowCreateTempTables is deprecated since v4.1

SYSADMIN.Users

This table supplies information on users.

Column Name	Type	Description
`id`	biginteger	User ID
`name`	string	Username
`roles`	string	Role names of this user
`creationDate`	timestamp	Timestamp when the user data entry was created
`lastModifiedDate`	timestamp	Timestamp when the user data entry was last modified
`creator`	string	Name of the user who created the user data entry
`modifier`	string	Name of the user who last modified the user data entry
`loginAllowed`	boolean	Flag to signal if login for this user is allowed or not
`concurrentQueries`	integer	Maximum number of concurrent queries run by the user, -1 for unlimited
`maxQueryTime`	integer	Maximum query execution time in minutes, -1 for unlimited
`maxRows`	integer	Maximum number of rows the user can retrieve in one query, -1 for unlimited
`timezone`	string	Default timezone of the user (`timezoneId` column from the SYSADMIN.Timezones table). Timezone will only affect schedules of type `CRON`

Please note that any schedules without an explicitly specified timezone will run in the time zone of the user who owns them. If that user does not have a timezone set, the schedules will run in the server’s timezone.

loginAllowed available since v4.1

concurrentQueries, maxQueryTime, maxRows available since v4.8

timezone available since v4.11

SYSADMIN.Permissions

This table supplies information on permissions.

Column Name	Type	Description
`role`	string	Role name
`mappedToRole`	string	Role name this role is mapped to
`resource`	string	Resource name
`permission`	string	Permission string
`condition`	string	Row-based security condition
`isConstraint`	boolean	Insert/update values if the new value matches the permission condition or insert/update all values
`mask`	string	Column mask value
`maskOrder`	integer	Mask order if there are several masks for one column
`creationDate`	timestamp	Timestamp when the permission was created
`lastModifiedDate`	timestamp	Timestamp when the data source was modified the last time
`creator`	string	Name of the user who created the permission
`modifier`	string	Name of the user who last modified the permission

mappedToRole column available since v4.2

[data-colorid=uhqo9vhhhi]{color:#333333} html[data-color-mode=dark] [data-colorid=uhqo9vhhhi]{color:#cccccc}[data-colorid=xpj8hmqp1l]{color:#333333} html[data-color-mode=dark] [data-colorid=xpj8hmqp1l]{color:#cccccc}SYSADMIN.Roles

SYSADMIN.Users

SYSADMIN.Permissions

SYSADMIN.Roles