查看Menu和Component的安全性

Macey_yu

• <P> SELECT A.OPRID
• , C.ROLENAME AS ROLE
• , D.CLASSID AS PERMISSION
• , D.MENUNAME AS MENU
• , D.BARITEMNAME AS COMPONENT
• , D.PNLITEMNAME AS PAGE
• , E.PAGEACCESSDESCR
• , D.DISPLAYONLY
• FROM PSOPRDEFN A
• , PSROLECLASS B
• , PSROLEUSER C
• , PSAUTHITEM D
• , PSPGEACCESSDESC E
• WHERE B.ROLENAME = C.ROLENAME
• AND A.OPRID = C.ROLEUSER
• AND B.CLASSID = D.CLASSID
• AND D.MENUNAME not IN ('APPLICATION_DESIGNER','CLIENTPROCESS','DATA_MOVER' ,'IMPORT_MANAGER','OBJECT_SECURITY','QUERY')
• AND D.MENUNAME NOT LIKE 'WEBLIB%'
• AND D.MENUNAME  LIKE 'Z_%'
• AND D.AUTHORIZEDACTIONS = E.AUTHORIZEDACTIONS
• AND A.OPRID = 'XXXXXX'
• --AND D.MENUNAME = 'PV_MAIN_MENU'
• --AND B.CLASSID = 'CPSDPALL'
• --AND D.BARITEMNAME = 'UPG_RUN_AEC'
• --AND D.PNLITEMNAME = 'PV_REQ_HDR_DEFAULT'
• ORDER BY 2
• </P>
  

复制代码