RSEC_DYNVIEW_VW (SQL View)	Index Back
Dynamic View Privileges View Privilege definition used

RSEC_DYNVIEW_VW

(SQL View)

Dynamic View Privileges

View Privilege definition used

SELECT RSEC_VIEW_ID , RSEC_OBJECT_ID , DESCR FROM %Table(RSEC_VIEW_DEFN) WHERE RSEC_DOMAIN_TYPE = '0001' AND RSEC_IMPLICIT_FLG = 'N' AND SQLID <> ' '

Related Language Record: RSEC_DYNVIEWLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSEC_VIEW_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier of a view list used in application security.

2 RSEC_OBJECT_ID Character(30) VARCHAR2(30) NOT NULL Security Object ID used for defining application security objects.
Prompt Table: RSEC_VP_OBJ_VW

3 RSEC_DESCR Character(30) VARCHAR2(30) NOT NULL Membership or view list description field used in application security views.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_VIEW_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier of a view list used in application security.
2	RSEC_OBJECT_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Object ID used for defining application security objects. Prompt Table: RSEC_VP_OBJ_VW
3	RSEC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Membership or view list description field used in application security views.