RSEC_PRFVLISTVW

(SQL View)
 Index Back

Security Profile View List

View that shows the view lists associated to applicaiton security profile.

SELECT PV.RSEC_PROFILE_ID , VL.RSEC_VIEW_ID , VL.DESCR FROM %Table(RSEC_PROFILEVDM) PV , %Table(RSEC_VIEW_DEFN) VL WHERE PV.RSEC_VIEW_ID = VL.RSEC_VIEW_ID

  • Related Language Record: RSEC_PRFV_LNGVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description