PSPRSM_PERM_VW

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 Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PORTAL_SECTYPE Character(40) VARCHAR2(40) NOT NULL Portal Registry Security Holder: Public, Author Access or Permission List
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19