RY_AGG_SCRTY_VW

(SQL View)
 Index Back

Dialog Security View

This view shows all the users authorized to view the dialogs aggregate reports.

SELECT OPRID , DIALOG_ID FROM PS_RY_AGG_OPR_VW UNION SELECT OPRID , DIALOG_ID FROM PS_RY_AGG_OPROL_VW UNION SELECT OPRID , DIALOG_ID FROM PS_RY_DLG_OPRA_VW UNION SELECT OPRID , DIALOG_ID FROM PS_RY_DLG_OPRM_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.