This document shows how to locate queries used for security:

CSU Security queries are unique to CSU system.

• Important: Do not edit these queries. You can copy the query and rename it.

Step 1: Navigate to Query Manager.

• Menu > Reporting Tools > Query > Query Manager

Step 2: Search for the CSU Security queries:

• Query names begin with CSU_SEC%

• The CSU Security Queries are returned in the search results.

Step 3: Select the query that you want to use.

These queries are provided by Oracle

• User ID Queries
• Role Queries
• Permission List Queries
• PeopleTools Objects Queries
• Definition Security Queries
• Access Log Queries

Step 1: Navigate to Common Queries.

• Menu > PeopleTools > Security > Review Security Information

Step 2: Click a link to use the queries available

End of Article