SYSADMIN.Roles
このテーブルは、ロールに関する情報を提供します。
Column Name | Type | Description |
---|---|---|
| biginteger | Role ID |
| string | Role name |
| boolean | Parameter indicating if it is possible to create temporary tables with this role |
| string | Usernames in this role |
Parameter allowCreateTempTables
is deprecated since v4.1
SYSADMIN.Users
このテーブルは、ユーザーに関する情報を提供します。
Column Name | Type | Description |
---|---|---|
| biginteger | User ID |
| string | Username |
| string | Role names of this user |
| timestamp | Timestamp when the user data entry was created |
| timestamp | Timestamp when the user data entry was last modified |
| string | Name of the user who created the user data entry |
| string | Name of the user who last modified the user data entry |
| boolean | Flag to signal if login for this user is allowed or not |
| integer | Maximum number of concurrent queries run by the user, -1 for unlimited |
| integer | Maximum query execution time in minutes, -1 for unlimited |
| integer | Maximum number of rows the user can retrieve in one query, -1 for unlimited |
loginAllowed
is available since v4.1
concurrentQueries
,
, maxQueryTime
available since v4.8maxRows
SYSADMIN.Permissions
このテーブルは、権限に関する情報を提供します。
Column Name | Type | Description |
---|---|---|
| string | Role name |
| string | Role name this role is mapped to |
| string | Resource name |
| string | Permission string |
| string | Row-based security condition |
| boolean | Insert/update values if the new value matches the permission condition or insert/update all values |
| string | Column mask value |
| integer | Mask order if there are several masks for one column |
| timestamp | Timestamp when the permission was created |
| timestamp | Timestamp when the data source was modified the last time |
| string | Name of the user who created the permission |
| string | Name of the user who last modified the permission |
mappedToRole
column available since v4.2