GET USER LIST

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 6.0


GET USER LIST (userNames; userNumbers)

ParameterTypeDescription
userNamesString ArrayUser names as they appear
in the Password editor window
userNumbersNumeric ArrayCorresponding unique user ID numbers

Description

GET USER LIST populates the arrays userNames and userNumbers with the names and unique ID numbers of the users as they appear in the Passwords window.

The array userNames is filled with the user names displayed in the Passwords window, including users whose accounts are disabled (user names displayed in green in the Passwords window).

Note: Use the command Is user deleted to detect deleted users.

The array userNumbers, synchronized with userNames, is filled with the corresponding unique user ID numbers. These numbers can have the following values or ranges:

User ID number User description
1Designer user
2Administrator user
3 to 15000User created by the Designer of the database
(user #3 is the first user created by the Designer,
user #4 the second, and so on).
-11 to -15000User created by the Administrator of the database
(user #-11 is the first user created by the Designer,
user #-12 is the second, and so on).

See Also

GET GROUP LIST, GET USER PROPERTIES, Set user properties.

Error Handling

If you do not have the proper access privileges for calling GET USER LIST or if the Password system is already accessed by another process, an access privilege error is generated. You can catch this error with an error-handling method installed using ON ERR CALL.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next