MIN_MNU_CI_VW

(SQL View)
 Index Back

Mobile Menu Security

Mobile Menu Security view - returns all the mobile menus for a given user by their role permissions

SELECT B.OPRID , A.PORTAL_OBJNAME , B.OPRDEFNDESC , B.OPRCLASS , A.BCNAME , A.BCMETHOD FROM PS_MIN_CMP_INTFC A , PS_MIN_CI_SEC_VW B WHERE A.BCNAME = B.BCNAME AND A.BCMETHOD = B.BCMETHOD AND A.AUTHORIZEDACTIONS = B.AUTHORIZEDACTIONS

# 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_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
4 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
5 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).
6 BCMETHOD Character(30) VARCHAR2(30) NOT NULL Method