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 NameField TypeColumn TypeDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
PORTAL_SECTYPECharacter(40)VARCHAR2(40) NOT NULLPortal Registry Security Holder: Public, Author Access or Permission List
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19