RY_IND_SCRTY_VW

(SQL View)
 Index Back

Dialog Security View

This view shows all the users authorized to view the dialogs �individual/integrated reports.

SELECT OPRID , DIALOG_ID FROM PS_RY_IND_OPR_VW UNION SELECT OPRID , DIALOG_ID FROM PS_RY_IND_OPROL_VW UNION SELECT OPRID , DIALOG_ID FROM PS_RY_DLG_OPRA_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.