Content Reference - Check if a user has access to a CREF

-- to check which perm list have access to a portal content ref/folder
SELECT * FROM PSPRSMPERM
WHERE PORTAL_OBJNAME ='HC_GP_SS_EE_PSLP_GBL'


-- to check if a user has access to a portal content ref/folder
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 'HCHR_PE_EMPL_LEAVE'
AND X.ROLEUSER = 'esstest1'

-- CHECK to see if user has access to menuitem
select * from PSAUTHITEM A, PSROLECLASS B, PSROLEUSER C
WHERE A.MENUNAME = 'PORTAL_COMPONENTS_HR'
AND A.PNLITEMNAME LIKE '%HR_PE_EMPL_LV_EXT%'
AND A.CLASSID = B.CLASSID
AND B.ROLENAME = C.ROLENAME
AND C.ROLEUSER = 'esstest1'
-- which permission lists have access to a menu item
select * from PSAUTHITEM A
WHERE A.MENUNAME = 'PORTAL_COMPONENTS_HR'
AND A.PNLITEMNAME LIKE '%HR_PE_EMPL_LV_EXT%'