RY_DLG_OPROL_VW (SQL View)	Index Back
Dialog Security View This view shows all the roles as users that are authorized to view the dialogs. Dialog must be secure and authorization to view dialog must be on

RY_DLG_OPROL_VW

(SQL View)

Dialog Security View

This view shows all the roles as users that are authorized to view the dialogs. Dialog must be secure and authorization to view dialog must be on

SELECT A.DIALOG_ID ,B.ROLEUSER FROM PS_RY_DLG_TEAM_ALL A , PSROLEUSER B , PS_RYEDIALOG D WHERE A.ROLENAME = B.ROLENAME AND a.ry_authorized_dlg ='Y' AND A.DIALOG_ID = D.DIALOG_ID AND D.RY_SECURE_DIALOG = 'Y'

# 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).

#	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).