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

Posted by Nitin Pai
Comments (0)
January 26th, 2009

Comments (0)