RSEC_KVP_OBJVW (SQL View)	Index Back
Security Profile Member Object This view provides a list of membership security objects related to a security profile

RSEC_KVP_OBJVW

(SQL View)

Security Profile Member Object

This view provides a list of membership security objects related to a security profile

SELECT A.RSEC_PROFILE_ID , B.RSEC_VIEW_ID , B.RSEC_OBJECT_ID FROM %Table(RSEC_PROFILEVDM) A , %Table(RSEC_VIEW_DEFN) B WHERE A.RSEC_VIEW_ID = B.RSEC_VIEW_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSEC_PROFILE_ID Character(30) VARCHAR2(30) NOT NULL A unique identifier of security profile for application security.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_PROFILE_ID	Character(30)	VARCHAR2(30) NOT NULL	A unique identifier of security profile for application security.
2	RSEC_VIEW_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier of a view list used in application security.
3	RSEC_OBJECT_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Object ID used for defining application security objects. Prompt Table: RSEC_MEM_OBJ_VW