MIN_POR_SEC_VW

(SQL View)
 Index Back

Portal Security View

Mobile Inventory View for Portal Security

SELECT D.OPRID , A.PORTAL_PERMNAME , D.OPRDEFNDESC , A.PORTAL_OBJNAME , A.PORTAL_PERMTYPE , A.PORTAL_REFTYPE , B.ROLENAME FROM PSPRSMPERM A , PSROLEUSER B , PSROLECLASS C , PSOPRDEFN D WHERE B.ROLENAME = C.ROLENAME AND B.ROLEUSER = D.OPRID AND A.PORTAL_NAME = 'EMPLOYEE' AND A.PORTAL_REFTYPE IN ('F', 'C') AND (A.PORTAL_PERMNAME = C.CLASSID OR A.PORTAL_PERMNAME = B.ROLENAME)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PORTAL_PERMNAME Character(30) VARCHAR2(30) NOT NULL Permission Name
3 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
4 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
5 PORTAL_PERMTYPE Character(30) VARCHAR2(30) NOT NULL Permission Type
6 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).