Running the Security Analyzer by User or Group Report (R98OWSECB)

The Security Analyzer by User or Group Report (R98OWSECB) report presents security analysis information for each user ID, each group, and each data source. The report is sorted either by user ID or user group, depending on which processing option you select. This columnar data appears in the report:

  • User ID

  • Role

  • Password Change Frequency

    The number of days before a user must change their password. This data can be set by individual user ID or by group.

  • Data Source

    The data source to which the user is secured. A blank indicates all data sources.

  • System User

    The actual user that the software uses to connect to the DBMS that you specified as the data source. The system user that is defined here must match the user value that is defined in the DBMS.

Access the Work With Batch Versions - Available Versions form to run the Security Analyzer by User or Group Report (R98OWSECB).

  1. Select a version and click Select.

    The default version is XJDE0001. It creates a report for all user IDs for all data sources.

    By default, the XJDE0001 version has the processing option for this report set to 1. This option generates a report by user ID.

    To generate a report by role, you can prompt for processing options and then, on the User Setup tab, change the value to 2.

  2. On the Version Prompting form, click Submit.

  3. Complete the processing options as necessary, and then click OK.

  4. On Report Output Destination, select any of these options:

    • On Screen

    • To Printer

    • Export to CSV

  5. If desired, select the OSE Interface Name option and type a name in the field that appears.