Hi…

I need sql to help identify all users that have access to a specific page.

Thanks  

Thanks for posting your question!

SELECT DISTINCT B.MENUNAME, B.BARNAME, B.BARITEMNAME,

D.PNLNAME,C.PAGEACCESSDESCR, B.DISPLAYONLY, F.ROLEUSER

FROM PSROLECLASS A, PSAUTHITEM B, PSPGEACCESSDESC C,

PSPNLGROUP D,

PSMENUITEM E, PSROLEUSER F

WHERE B.MENUNAME = E.MENUNAME

AND B.BARNAME = E.BARNAME

AND B.BARITEMNAME = E.ITEMNAME

AND D.PNLGRPNAME = E.PNLGRPNAME

AND A.CLASSID = B.CLASSID

AND B.MENUNAME NOT IN (‘APPLICATION_DESIGNER’,’OBJECT_SECURITY’,’QUERY’,

‘PERFMONPPMI’,’IMPORT_MANAGER’,’CLIENTPROCESS’,

‘DATA_MOVER’)

AND B.MENUNAME NOT LIKE ‘WEBLIB%’

AND B.AUTHORIZEDACTIONS = C.AUTHORIZEDACTIONS

AND A.ROLENAME = F.ROLENAME

AND D.PNLNAME = ‘&EnterPageName’

ORDER BY 2

The above SQL should help you determine all the users who

have access to a given page.

Thanks

Nitin Pai

Posted by Nitin Pai
Comments (0)
September 15th, 2008

Comments (0)