Oracle PeopleSoft Query uses query access group trees to control security of the tables in your PeopleSoft database. You define a hierarchy of record components, based on logical or functional groupings, and then give users access to one or more branches of the tree.


Users can use PeopleSoft Query to retrieve information only from those tables whose record definitions they have access to.


Using PeopleSoft Query Access Manager, you can create, view, and update query access group trees.


Query access group trees contain two types of nodes, which are groups and records:

• Groups represent of a set of child groups or records.

• Records represent a PeopleSoft record definition.


In this topic, you will review query access group trees.

Table of Contents