All users can display and print a user report from the User Report option on the Admin > Security menu of the Data Administration tool. In addition, security administrators can run a user report by navigating to the Edit User List and Edit Data Security dialog boxes from Admin > Security menu and selecting the Report option.

For more information, see Edit User List option and Edit Data Security .

User reports include a list of user IDs and user names and indicate which users IDs are protected by passwords.

To generate a user report:

  1. Choose Admin > Security > User Report from the graphical Data Administration tool or the character Data Dictionary. A report similar to the following is generated:
    Figure 1. User Report dialog box

    The following table lists the descriptions of all the fields included in the report:
    Field Description
    User ID Specifies a unique identifier assigned to each user.
    Domain Specifies the name of an OpenEdge security domain that is defined and configured in the database.
    User Name Specifies the full name of the user.
    Pwd? Specifies whether the user has a password set (yes or no).
    SQL only

    Specifies whether the user’s access to a database is restricted only through SQL (yes or no).
    New Pwd? Specifies whether the password is generated using the GENERATE-PASSWORD-HASH function, which supports password hash generation using algorithms that are approved by the National Institute of Standards and Technology (NIST). (yes or no).
    Note: If the value in this field is no, it signifies that the passwords have been encoded using the ENCODE() function.

    For more information, see GENERATE-PASSWORD-HASH function .
  2. Click Print to output the report to a printer or file. The Print Options dialog box appears.
  3. Specify the report destination. You can print the report, or save it on a file. If you want to save the report to a file, specify the file name and whether to append the report to an existing file.
  4. Specify the page length. then click OK. The report is directed to the specified output destination.