users

This specifies users who have access to the scheduling system. By default the administrator user is created to enable creation of other users. Users should be created to enable access to the applications and to implement security through the restriction of access to groups. See entities Group, User Group.

Syntax:

[ DynamicComponentDependency ] users UsersName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(256) Specifies the user id.
last_password_change Date When the user last changed their password.
lower_id String(256) Alternate key for id. Maintained automatically.
name String(256) Name of user.
user_password String(256) The password to be used by the user to gain access to functionality.

Optional columns

Column Name Data Type Description Default Value
enable Number (0 = False, 1 = True) Flag to enable or disable account access. True
force_password_change Number (0 = False, 1 = True) Forces the user to change password on next logon. True
hash_method Number Hash method used on the users password. 1
profile_id String(32) Profile the user should use. DEFAULT
first_name String(256) The first name of the user.
language_id String(32) Default language translation to be used for this user.
last_password_client String(100) Users client id when their password was last changed.
password_salt String(32) Salt used when hashing the users password.
surname String(256) The surname of the user.
verification_code String(32) A code to verify that a user can be activated. 


            users Users {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  last_password_change,
                     ..                  lower_id,
                     ..                  name_,
                     ..                  user_password,
                  -- optional columns
                     ..                  enable,
                     ..                  force_password_change,
                     ..                  hash_method,
                     ..                  profile_id,
                     ..                  first_name,
                     ..                  language_id,
                     ..                  last_password_client,
                     ..                  password_salt,
                     ..                  surname,
                     ..                  verification_code
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling Users.

UsersName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.