Showing posts with label Portal. Show all posts
Showing posts with label Portal. Show all posts

Friday, 19 October 2012

Table to move the Tab Contents and Layout settings

PSPRSMHPASGPGLT

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%'