PSPRSM_PERM_VW

(SQL View)
 Index Back

Portal Registry Permissions


SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PORTAL_SECTYPE FROM %Table(PSPRSM_SRCH_VW) A WHERE (A.PORTAL_SECTYPE <> '2' ) UNION SELECT C.PORTAL_NAME , C.PORTAL_OBJNAME , %TrimSubstr(C.PORTAL_PERMTYPE,1,30) %Concat ':' %Concat C.PORTAL_PERMNAME FROM (%Table(PSPRSM_SRCH_VW) B LEFT OUTER JOIN %Table(PSPRSMPERM) C ON B.PORTAL_NAME = C.PORTAL_NAME AND B.PORTAL_REFTYPE = C.PORTAL_REFTYPE AND B.PORTAL_OBJNAME = C.PORTAL_OBJNAME) UNION SELECT D.PORTAL_NAME , D.PORTAL_OBJNAME , 'S:Admin' FROM %Table(PSPRSM_SRCH_VW) D

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 PORTAL_SECTYPE Character(40) VARCHAR2(40) NOT NULL Portal Registry Security Holder: Public, Author Access or Permission List