Showing posts with label component permission lists. Show all posts
Showing posts with label component permission lists. Show all posts

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;