Hi,
I wanted to know how can one give ‘display only’ permission list to Administer workforce module.
Thanks in Advance.
– Asha

Thanks for posting your question!

 You can do it by following below steps.
1.       Create a new permission list
2.       Add all Menus which are part of Workforce Administration
3.       Grant Authorizations to appropriate Components
4.       Ensure that you check Authorized and Display Only for the Pages
 ask-the-expert-48

Use below SQL to identify all the menu names (step 2) under the Workforce
Administration Folder.

 SELECT DISTINCT PORTAL_URI_SEG1
FROM
PSPRSMDEFN A
WHERE PORTAL_NAME = ‘EMPLOYEE’
AND A.PORTAL_PRNTOBJNAME != ‘ ‘
START WITH A.PORTAL_LABEL = ‘Workforce Administration’
CONNECT BY  PRIOR A.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME
/
Use below PL/SQL if you need to automate steps 3 & 4.
DECLARE
CURSOR C1 IS
SELECT DISTINCT PORTAL_URI_SEG1
FROM
PSPRSMDEFN A
WHERE PORTAL_NAME = ‘EMPLOYEE’
AND A.PORTAL_PRNTOBJNAME != ‘ ‘
START WITH A.PORTAL_LABEL = ‘Workforce Administration’
CONNECT BY  PRIOR A.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME;
CURSOR C2 (V_MENUNAME VARCHAR2) IS
SELECT DISTINCT MENUNAME, BARNAME, BARITEMNAME, PNLITEMNAME
FROM PSAUTHITEM
WHERE MENUNAME = V_MENUNAME;
BEGIN
FOR CUR_REC IN C1
LOOP
FOR CUR_REC2 IN C2(CUR_REC.PORTAL_URI_SEG1)
LOOP
INSERT INTO PSAUTHITEM VALUES
(‘TEMP1’,            –NEW PERMISSION LIST
CUR_REC2.MENUNAME,
CUR_REC2.BARNAME,
CUR_REC2.BARITEMNAME,
CUR_REC2.PNLITEMNAME,
1,                   –DISPLAYONLY ENABLED
2);                  –AUTHORIZED ACTIONS
END LOOP;
END LOOP;
END;

/ 

 

Thanks
Nitin Pai

Posted by Nitin Pai
Comments (0)
November 21st, 2008

Comments (0)