Understanding Query Access Group Trees

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: groups and records.

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

• Records represent a PeopleSoft record definition.

PeopleSoft Query does not apply the following query tree securities to role, process and archive types of query:

• Table set control record

• Row-level security

• Query access tree security