PSACLMENU_VW2

index back

List all non-popup menus

This SQL view provides a list of menu names in the ACL_MENU2 page of the Permissions List component (ACCESS_CNTRL_LISTX)
SELECT DISTINCT A.MENUNAME , A.CLASSID FROM PSAUTHITEM A WHERE A.MENUNAME <> 'APPLICATION_DESIGNER' AND A.MENUNAME <> 'IMPORT_MANAGER' AND A.MENUNAME <> 'DATA_MOVER' AND A.MENUNAME <> 'OBJECT_SECURITY' AND A.MENUNAME <> 'QUERY' AND A.MENUNAME <> 'APPLICATION_REVIEWER' AND A.MENUNAME <> 'SECURITY_ADMINISTRATOR' AND A.MENUNAME <> 'APPLICATION_MSG_MONITOR' AND A.MENUNAME <> 'ANALYSIS_DB_MANAGER' AND A.MENUNAME <> 'CLIENTPROCESS' AND A.MENUNAME <> 'MESSAGE_AGENT' AND A.MENUNAME <> 'REN' AND A.MENUNAME <> 'PERFMONPPMI' AND A.MENUNAME NOT LIKE 'WEBLIB_%'

  • Parent record: PSOPRDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

    Prompt Table: PSMENU_PRMTVW1

    CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19