SQL Check if a user has access to a PeopleSoft portal content reference/folder - PIA

SQL to check if a user has access to a PeopleSoft portal content reference/folder -PIA

 

SELECT * FROM (

SELECT A.*, C.ROLEUSER, C.ROLENAME

FROM PSPRSMPERM A, PSROLECLASS B, PSROLEUSER C

WHERE A.PORTAL_PERMTYPE = 'P' AND A.PORTAL_PERMNAME= B.CLASSID AND B.ROLENAME = C.ROLENAME

UNION

SELECT A.*, C.ROLEUSER, C.ROLENAME

FROM PSPRSMPERM A, PSROLEUSER C

WHERE A.PORTAL_PERMTYPE = 'R' AND A.PORTAL_PERMNAME = C.ROLENAME) X

WHERE X.PORTAL_NAME = 'EMPLOYEE'

and X.PORTAL_OBJNAME like '%CUSTOMER%'

AND X.ROLEUSER = 'aravindkumar'

 

Best Regards

Aravind Kumar R

System Analyst/Peoplesoft Practice
Birlasoft • 36, Vijayaraghava Road , T. Nagar, Chennai 600 017 (INDIA)
Cell: +91 9566750166

************************************************************************************************************************************************************************************
"This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the mail.admin@birlasoft.com immediately without opening the mail and attachment . Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email
************************************************************************************************************************************************************************************