Appearance
Show Users
Shows the users.
Permissions
| Command Kind | Needed User Kind |
|---|---|
| Read | Admin, Sys |
Parameters
| Name | Type | Description | Required | Default | Values |
|---|---|---|---|---|---|
| Find | string | Value to search for in name and captions. | no | ||
| MaxRecords | integer | Maximum number of records to be returned. The default value is 500000. | no | 500000 | |
| Sort | string | Sorts the output by name or caption ([Field].[Caption1]). The field can be [User]/[Name], [Caption1], [Caption2], [Caption3], [Caption4], [Caption5], [Caption6], [Caption7], [Caption8], [Caption9], [Caption10]. Sort can be Ascending (Asc) or Descending (Desc), e.g. [Caption1].[Ascending] | no |
Result
| Name | Type | Description |
|---|---|---|
| User | string | Name of the user. |
| Active | boolean | If 'True' the user is active and can connect. It can be set with the command 'Edit User'. |
| Admin | boolean | If 'True' the user has admin permissions. |
| Designer | boolean | If 'True' the user has designer permissions. |
| Import | boolean | If 'True' the user has import permissions. |
| Fixed | boolean | If 'True' the user cannot be changed ('Sys' or 'SysTech'). |
| Domain | string | Domain of the user. |
| Role | string | Role of the user. |
| IndividualLog | boolean | If 'True' the user has an individual log file. The file name contains the database name, username and the date: Data_<Database>@<User>_YYYY_MM_DD.log. |
| Worksheet | string | Start worksheet of the user. |
Code
text
SHOW USERS
FIND=[string]
MAXRECORDS=[integer, default=500000]
SORT=[string]