October 4, 2011

SQL to determine the Permission Lists associated with a component

SELECT a.classid as Permission_List,
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 b.baritemname = 'SPECIFY_COMPONENT_HERE'
AND b.authorizedactions = c.authorizedactions;

No comments:

Post a Comment