Securing PS/nVision Elements

This section describes how to:

  • Secure PS/nVision menu items.

  • Secure report layouts.

  • Secure and share report requests in PIA.

  • Secure and share report request in Windows client.

Use the Page Permissions page (ACL_PAGES2) in PeopleSoft Security to specify the page permissions that control the operations users can perform in PS/nVision. Authorizations specified at the Page Permissions page are applied to both the Windows client and the PeopleSoft Pure Internet Architecture (PIA).

Image: Page Permissions page

This example illustrates the fields and controls on the Page Permissions page.

Page Permissions page

To set component permissions in PIA:

  1. Select PeopleTools > Security > Permissions & Roles > Permission Lists.

  2. Select the required nVision Permission list.

  3. Select the Pages tab.

  4. Click the Edit component link, corresponding to the required menu, to display the Component Permissions page.

  5. Click the Edit Pages button for a component to display the Page Permissions page.

  6. Change the settings to authorize the action or leave the settings as display-only.

    When selecting page permissions, you must select both an action and the Authorized option. For example, when you allow a user to run report requests, you must select the Update/Display button and the Authorized option adjacent to the RUN_REPORT page name on the Page Permissions page.

  7. Click the OK button.

Important! If no items are authorized, you cannot run PS/nVision at all.

nVision is controlled through individual components associated with the REPORT_BOOKS and NVISION menus.

The following table lists the available PS/nVision page permissions and describes the actions they control.

Page Permission

Action Controlled

DEFINE_LAYOUT

Allows the user to use the Open Layout, Layout Definition, and similar menus in Excel.

OPEN_REPORT

Enables the Open button in the PeopleSoft nVision Report Request dialog box on the Windows client.

EDIT_REPORT

Allows the user to modify values in the PeopleSoft nVision Report Request dialog box.

Note: The EDIT_REPORT setting does not control access to report layout (Excel XNV) files. To restrict users from accessing XNV files entirely, use the Network Security settings.

RUN_REPORT

Allows the user to run report requests using the Run button in the PeopleSoft nVision Report Request dialog box, the Run Current Request menu item in the Windows client, and the Run button in the web report request.

SAVE_REPORT

Enables the Save button in the PeopleSoft nVision Report Request dialog box on both the Windows client and the web.

Note: When you make changes to a report request, it is automatically saved when you run the request. To save a report request without running it, click the Save button. You cannot change a report request without saving it.

DELETE_REPORT

Enables the Delete button in the PeopleSoft nVision Report Request dialog box on both the Windows client and the web.

OPEN_SCOPE

Enables the Open button in the PeopleSoft nVision Scope Definition dialog box on the Windows client.

EDIT_SCOPE

Allows the use to modify values in the PeopleSoft nVision Scope Definition dialog box on the Windows client.

SAVE_SCOPE

Enables the Save button in the PeopleSoft nVision Scope Definition dialog box on the Windows client.

DELETE_SCOPE

Enables the Delete button in the PeopleSoft nVision Scope Definition dialog box on the Windows client.

PERFORMANCE_OPTS

Enables the nVision Performance menu item, by which you access the Tree Performance Options dialog box.

Report layouts (XNV files) are stored on a file server and not in the PeopleSoft database. Set up network security so that only appropriate users are able to modify or delete report layout (XNV) files in the report layout directories of the network.

With web-based PS/nVision reporting, reports launched from the browser are run through PeopleSoft Process Scheduler and executed on a report server. The file server that stores the layouts is associated with the report server.

A report server is a Windows NT machine with PS/nVision (PeopleTools client software), Microsoft Excel, and PeopleSoft Process Scheduler installed. Process Scheduler selects the layout from the PS/nVision layout directory path defined in the Process Scheduler configuration. If you restrict access to this directory on the report server, unauthorized users cannot modify shared report layouts. Additionally, access to the PS/nVision directories on the Process Scheduler report server should be restricted.

If the report is run using the Windows client, a user authorized to define layouts can point to the PS/nVision layout directory (as defined in Configuration Manager) on the local drive and then modify and save the layout.

If a user has a PS/nVision user profile defined in PeopleSoft Security where only RUN_REPORT is selected, and all other settings (for example, EDIT_REPORT, SAVE_REPORT) are cleared, the user cannot create a new report request, because the Save button is disabled.

Note: When the report request is run, access to ledger or record data itself is still controlled by the row-level security defined for that user.

You can either share and secure nVision reports in PIA or in Windows client.

In web-based PS/nVision reporting, the procedures and processes used to run a report are performed using the different pages of the Report Book menu. Those actions include defining and running report requests, defining and running report books, defining scopes, and running DrillDowns. You can control access to these menu items and customize the pages to allow users restricted access to certain report requests.

Note: For the Scope and Delivery Templates link on the nVision Report Request page (NVS_REPORT_RQST), the system automatically displays an nVision output option page based on the output type. Security permissions for these secondary pages are inherited from the parent Report Request page, and the Display Only option set in the nVision Report Request component for these pages is ignored.

By default, only the creator of a report request has full access to that request. The creator can select to share the report request with other users or to change the access mode using the Share This Report Request link on the nVision Report Request page.

You can select Reporting Tools > PS/nVision > Define Report Request to access the nVision Report Request page. In this page, click the Share This Report Request link to display the nVision Share Report Request page, where report request creators can view or change the access mode.

Note: You can share and secure nVision reports either in PIA or in Windows client.

Image: nVision Share Report Request page

This example illustrates the fields and controls on the nVision Share Report Request page. Definitions for the fields and controls appear following the example.

nVision Share Report Request page

Field or Control

Definition

Access Mode

Specifies the access availability for the report request. Select the Public option for all users to view or modify the request. Select the Secured option to specify which users have full access to the report.

By default, users have the right to share report requests and access the Security Report Request page. You can change the default value using the Use Secure Rep Rqst in nVision (Use Secure Report Request in nVision) option on the PeopleTools Options page to restrict the users with this right.

See PeopleTools Options.

Note: If you change the access mode from secured to public, all the users and groups who had access to the report will be removed. If you then change the access mode back to secured, you will need to reassign the users and groups.

ID Type

Select the User option to add a user, or the Role option to add a user role.

Distribution ID

Enter a valid user or role name, or select one from the list. You can add more users by clicking the + sign. If you selected User from the ID Type list, valid users appear; if you selected the Role option in the ID Type field, user roles appear.

Since report requests are keyed by business unit, the business unit validation is done for each shared user or role when a report request is opened. If a user or role does not have access to a business unit, that user does not have access to the report request even if she or he is given access through the Access Mode page.

Note: If a report book contains a report request to which a user does not have access, that user will not be able to view that report request. A message appears when the user opens the report book.

In Windows-client PS/nVision reporting, you can use the PS/nVision VBA interface to programmatically create a customized report request that will restrict users to certain parameters and functions of the report requests.

Administering Report Requests

Use the nVision Report Request Admin page to administer your report requests, including:

  • Removing a request.

  • Transferring a request from one user to another.

  • Making a request public.

Image: nVision Report Request Admin page

This example illustrates the fields and controls on the nVision Report Request Admin page. Definitions for the fields and controls appear following the example.

nVision Report Request Admin page

Field or Control

Definition

Source User ID

The user whose report requests will be administered.

Target User ID

The user ID to which the selected report requests will be transferred if the Transfer Report Request button is clicked.

No. of Records Affected

The number of records that will be affected (moved, transferred, or made public) by the selected operation.

Move Report Request

Click to remove the source user's report request.

If the report request is not shared by any other user, the report request will be deleted. If the report request has been shared by users other than the source user, only the source user will be removed.

Transfer Report Request

Click to remove the source user from the report request and grant access to the target user.

Make Report Request Public

Click to make all report requests owned by the source user available for any user to view and edit.

In Windows Client of PeopleSoft nVision, you have the flexibility of making report request either public or private. By default, all nVision report requests created in Windows clients are public.

All users who create and view reports must have the required privileges to use the Business Unit from which the reports are generated. If the report creators define the report as secured, other users can use the secured reports only if the report creators have transferred the reports to them. For example, if user A creates a report request and shares it with user B, then only user B will have access to that report request. However, in the same client session, if the Open PeopleSoft nVision Report Request dialog box or the PeopleSoft nVision Report Request dialog box still retains the shared report request information, user A will have a temporary access to the shared report request. When these dialog boxes are refreshed with other report requests information or the client session is closed, then user A will no longer have the access to the shared report request.

Report creators can use the nVision Share Report Request dialog box to change the access mode of reports from public to private, and vice versa.

Image: nVision Share Report Request dialog box

This example illustrates the fields and controls on the nVision Share Report Request dialog box.

nVision Share Report Request dialog box

Securing Report Requests in PS/nVision Windows Clients

To secure report requests in PS/nVision Windows clients:

  1. Select nVision > Report Request from the nVision toolbar.

    The PeopleSoft nVision Report Request dialog box appears.

  2. Enter the required values for the new report request, and click the Save button.

  3. Click the Run button to generate the report instance.

  4. Select nVision > Share Report Request from the nVision menu.

    The Share Report Request dialog box appears.

  5. Accept the default settings of Secured.

  6. Double-click the ID Type field.

    A list of contain values for ID type appears.

  7. Select an user to share this report instance with.

    Alternatively, select a roles to share this report instance to users with certain roles.

  8. After selecting ID type or role, double-click the Distribution ID field or the Distribution List field.

    If the ID type cell is User, a list of users appears. If the ID type cell is Roles, a list of roles appears.

  9. Optionally, repeat step 6 to 8 for adding other users and roles.

  10. Click the OK button to make the report instance secured.

Sharing Report Requests in PS/nVision Windows Clients

To share report requests in PS/nVision Windows clients:

  1. Select nVision > Report Request from the nVision toolbar.

    The PeopleSoft nVision Report Request dialog box appears.

  2. Enter the required values for the new report request, and click the Save button.

  3. Click the Run button to generate the report instance.

  4. Select nVision > Share Report Request from the nVision menu.

    The Share Report Request dialog box appears.

  5. Select the Public option to make the report instance public.

    A message appears for confirmation of this report instance to be available to all users.

  6. Click the OK button to make the report instance public.

    Alternatively, click the Cancel button to keep the report instance secured and viewed only by the shared users.

Removing User or Role From the Secured Distribution List

To remove an user or a role from the secured distribution list:

  1. Select nVision > Report Request from the nVision toolbar.

    The PeopleSoft nVision Report Request dialog box appears.

  2. Enter the required values for the new report request, and click the Save button.

  3. Click the Run button to generate the report instance.

  4. Select nVision > Share Report Request from the nVision menu.

    The Share Report Request dialog box appears.

  5. Select the required user to be removed, and click the Delete button.

    Alternatively, select the required role to be removed, and click the Delete button.

  6. Click the OK button to confirm that the selected user or role will be deleted.

  7. Optionally, repeat step 5 and 6 for removing other users and roles.

Setting Report Request Admin

Report creators can also use the PS/nVision Report Request Admin dialog box to transfer the private reports to other users for use.

To access the PS/nVision Report Request Admin dialog box:

  1. Open nVision client by selecting Start > Programs > PeopleSoft 8.x > nVision.

  2. Create a new nVision report, or open an exiting one.

  3. Select nVision > Transfer Report from the menu.

    The PS/nVision Report Request Admin dialog box appears.

Image: nVision Report Request Admin dialog box

This example illustrates the fields and controls on the nVision Report Request Admin dialog box, which enables report creators to move reports from one user to another user.

nVision Report Request Admin dialog box