RY_AGG_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 aggregate report must be on

RY_AGG_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 aggregate report must be on

SELECT B.ROLEUSER , A.DIALOG_ID FROM PS_RY_DLG_TEAM_ALL A , PSROLEUSER B , PS_RYEDIALOG D WHERE A.ROLENAME = B.ROLENAME AND a.ry_authorized_arpt ='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 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.

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