How do I search for information in your blog.
Collaborate had an article about determining user
access to pages and  there is SQL. I would rather copy/paste than to have to retype.

Thanks.    

Search functionality is not available on this site at
present. We are working to introduce this feature very soon.

Here is the SQL that you are looking for.

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

Thanks

Nitin Pai