Can be used to obtain User IDs and Employee IDs.

Job Aid: Query UserID and EmplID

This query finds users who can see a prompted component.  It also displays which role they have that allows them to see the component... as well as the authorized actions and whether its view only or update access.

This query prompts for begin and end date as well as CWID.  Shows a listing of logon/logoff activity by date for a given user for the prompted date range.

List of all users with an active job record.

This will identify if a row level permission list is not currently assigned.

Roles with no long descriptions.  Deselect those roles that have no users. Deselect those roles that have users that have their accounts locked.

Role Query for CHR_AM_Approver

Role Query for CHR_AM_NLT_Approver

Role Query for CHR_AM_No_Leave_Taken

Role Query for CHR_TL_Approver

Dynamic role CHR_TL_Timesheet_Employee

Find missing TL Group creation Security

T&L groups that are not used TL permission list security

Users that have a CMS access without any Job record at all.  Students and those with basic connectivity roles are excluded.  These are most likely Foundation, ASC, AppleOne, or HelpMates people.

Prompts for Component Name.  Lists the details of the Component... such as Menu Name, Component, Permission List, and Page Name.  Also shows the Role and PL that gives the user rights to see the Component.

CSU records on query trees that do not have query security

Find Menu - Component - Page for a prompted Record Name.

Find Portal Navigation by Component Name

Find Portal Navigation by Page Name

Prompts for Record Name... reports which users have the rights to see information on that record by listing the Role - PL - Query Tree that allows them to see the data.

Prompts for Primary Permission List.  Determines which user has a given PPL attached to their User Profile.

Reports on DeptID access for both DeptID drop down access as well as Timekeeper Access for a Row Security Permission List.

Find out which Roles / PLs have access to a prompted component.

CSU Roles and PLs with Correction Mode.

Prompts for Process Group... displays which user/role/pl has access to that process group.

Find the name of the all the Record(s) on a prompted page.

This query finds any Role and/or Permission Lists within a prompted page.  Lists Menu, Panel Item, Display Only, and Available Actions.

This query finds any Role and/or Permission Lists within a prompted page.  Lists Menu, Panel Item, Display Only, and Available Actions.

This query finds any Role and/or Permission Lists within a prompted page.  Lists Menu, Panel Item, Display Only, and Available Actions.

Prompts for Primary Permission List.  Determines which user has a given RSPL attached to their User Profile.

Find all the Query Trees and Access Groups that contain a prompted Record.  Good tool for determining why a user can't see a certain query.

Prompts for Query Tree Name and lists all the Permission Lists that have access to that Query Tree.

List out the records on a Tree

This query finds users who can see a prompted component.  It also displays which role they have that allows them to see the component... as well as the authorized actions and whether its view only or update access.

This query finds users who can see a prompted page.  Also lists the Role that allows them access to the page along with whether the access is view only and what the allowable actions are.

Prompts for OPRID... reports which records a user have the rights to see information.

Users who have access to level 1 data.  Users have unlocked profiles.  Names are not blank in PSOPRDEFN.  Based on hard coded page names.

Users who have access to level 2 data.  Users have unlocked profiles.  Names are not blank in PSOPRDEFN.  Based on hard coded page names.

List the Tree, Access Group, and Records available for a prompted Permission List.

Users that have query access to a prompted record.  It lists the Role, Permission List, Query Tree, and Access Group that allows them to see the record.

List all the records that are available for a prompted user.  It displays the Role Name, Permission List, Query Tree, and Query Access Group that allows the user access to records.

Lists a prompted Permission Lists Menu, Component, Page, and Actions.It accesses data from the following tables... PSCLASSDEFN, PSAUTHITEM, ACL_PAGES_VW2, and PSMENUDEFN.There is an expression to change the 1 and 0 found in the field DISPLAYONLY to Yes and No.There is also an expression to change the Action Number to Actions... so instead of 1 you get Add, instead of 2 you get Update/Display... along with all the intermediate permutations.

Lists a prompted Role's Navigation, Permission List, Menu, Component, Page, and Actions. Also, include hidden components.

Lists a prompted Role's Navigation, Permission List, Menu, Component, Page, and Actions.  No Fluid Pages

Lists a prompted Role's Navigation, Permission List, Menu, Component, Page, and Actions.

This query lists all the roles that belong to users who have their accounts locked.