Managing Query Profiles


Concept


Steps:

  1. Begin by navigating to the Permission Lists - Query Profile page.

     

    Click the PeopleTools link.

    Step 1
  2. Click the Permissions & Roles link.

    Step 2
  3. Click the Permission Lists link.

    Step 3
  4. Click the Search button.

    Step 4
  5. In this example, you will select the PTPT1200 permission list.

     

    Click in the Permission List field.

    Step 5
  6. Click the Query tab.

    Step 6
  7. Click the Query Profile link.

    Step 7
  8. Use the Query Profiles page to:

    •  Specify available query operations.

    •  Give users the right to run queries but not create them.

    •  Create regular queries but not workflow queries.

    •  Restrict the SQL operations that users can perform.

    Step 8
  9. Using this Query Profiles page, note that each permission list has its own query profile, and the combination of all permission lists that are assigned to a role determine the total query access for the role.

     

    User profiles inherit query access only through the roles that you assign to them.

    Step 9
  10. Use the Only Allowed to run Queries option to prevent users from being able to create queries and restrict them from running PeopleSoft Query.

     

    The values of the remaining options in this group are irrelevant if you have selected this option.

    Step 10
  11. Use the Allow creation of Public Queries option to enable users to create public queries.

    Step 11
  12. Use the Allow creation of Workflow Queries option to enable users to create workflow queries in addition to private queries.

     

    A workflow query is used in Oracle PeopleSoft Workflow, either as a database agent query or a role query. These queries can circumvent security restrictions; the system doesn’t check access group rights while running the query. To make sure that users can’t bypass the system’s security, clear this check box.

    Step 12
  13. Use the Maximum Rows Fetched option to enter a number to restrict the number of rows retrieved by a query. Some queries can return many data rows.

     

    For performance or time considerations, you may want users to view only some of those rows rather than all of them.

    Step 13
  14. Use the Run option to display the query results in a view-only grid control.

     

    This option is useful as users are refining their queries.

    Step 14
  15. Use the Run to Excel option to enable PeopleSoft Query passing the query results to Microsoft Excel, where users can analyze the results further.

    Step 15
  16. Use the Advanced SQL Options group box to restrict less experienced users from generating complex queries, as such queries can affect system performance.

     

    Step 16

You have successfully reviewed the Managing Query Profiles topic.

Table of Contents  Start Topic