Query profiles specify the type of access that users have when they work with PeopleSoft Query.

 

For example, you may want certain users to run only existing queries, not create new ones. You might also want to restrict the types of queries that users can create, limit the number of rows returned, or set the time that a query can run before it times out.

 

If a user has more than one permission list, PeopleSoft Query uses the highest time-out value as defined in the Time-out Minutes section of the user's permission lists.

 

You can also determine the output options that users have for generating their queries. The first level of security is access to PeopleSoft Query itself. If you don't give users access to PeopleSoft Query when you define their user IDs, they can't create or run queries. Not all users need to create their own queries.

 

In this topic, you will review query profiles.


Table of Contents