RY_DLG_SCRTY_VW

(SQL View)
 Index Back

Dialog Security View

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

SELECT DIALOG_ID , OPRID FROM PS_RY_DLG_OPR_VW UNION SELECT DIALOG_ID , OPRID FROM PS_RY_DLG_OPROL_VW UNION SELECT DIALOG_ID , OPRID FROM PS_RY_DLG_OPRA_VW UNION SELECT DIALOG_ID , OPRID FROM PS_RY_DLG_OPRM_VW

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