July 16, 2010

SQl to list pages in a Permission List

The below sql will list all the menus/components/pages & the kind of accesses (Update/Display) in a permission list...

SELECT b.menuname, b.barname, b.baritemname AS componentname, b.pnlitemname AS pagename,
c.pageaccessdescr,
DECODE (b.displayonly, 0, 'No', 1, 'Yes') AS displayonly
FROM psclassdefn a, psauthitem b, pspgeaccessdesc c
WHERE a.classid = b.classid
AND a.classid = 'PERMISSIONLISTNAME'
AND b.baritemname > ' '
AND b.authorizedactions = c.authorizedactions;