You can provide access to component / Menu from SQL script directly using excel sheet attached. You need to mention permission list, component name and menu name in excel columns excel sheet will generate the sql script of insert statements. You need to run the script SQL script and your permission list will get access of all menus/ components quickly.
Note: You need to create an empty permission list from PIA before you execute the script and you need to run portal Sync process after executing the script.
It is very time consuming to provide access to thousands of pages in components in permission list through PIA. This excel was made to help Peoplesoft Security Administrator.
Excel details:
Below is formula for SQL script:
="INSERT INTO PSAUTHITEM(CLASSID,MENUNAME,BARNAME,BARITEMNAME,PNLITEMNAME,DISPLAYONLY,AUTHORIZEDACTIONS) SELECT DISTINCT '"&F8&"',PSMENUITEM.MENUNAME,PSMENUITEM.BARNAME,PSMENUITEM.ITEMNAME,PSPNLGROUP.ITEMNAME,0,15 FROM PSPNLGROUP, PSMENUITEM WHERE PSPNLGROUP.pnlgrpname=PSMENUITEM.pnlgrpname AND PSMENUITEM.MENUNAME='"&A8&"' AND PSMENUITEM.pnlgrpname='"&C8&"';"
Note: You need to create an empty permission list from PIA before you execute the script and you need to run portal Sync process after executing the script.
It is very time consuming to provide access to thousands of pages in components in permission list through PIA. This excel was made to help Peoplesoft Security Administrator.
Excel details:
Below is formula for SQL script:
="INSERT INTO PSAUTHITEM(CLASSID,MENUNAME,BARNAME,BARITEMNAME,PNLITEMNAME,DISPLAYONLY,AUTHORIZEDACTIONS) SELECT DISTINCT '"&F8&"',PSMENUITEM.MENUNAME,PSMENUITEM.BARNAME,PSMENUITEM.ITEMNAME,PSPNLGROUP.ITEMNAME,0,15 FROM PSPNLGROUP, PSMENUITEM WHERE PSPNLGROUP.pnlgrpname=PSMENUITEM.pnlgrpname AND PSMENUITEM.MENUNAME='"&A8&"' AND PSMENUITEM.pnlgrpname='"&C8&"';"
No comments:
Post a Comment