How to create read only user for PeopleTools 8.54.13
Hi,
I am trying to create read only user for PIA access (Environment: Portal 9.1 with PT 8.54.13) with the below steps.
1) Created custom permission list and assign all the pages as display only using below SQL.
SQL> delete from psauthitem where classid = 'READONLY'
2 /
9 rows deleted.
SQL> insert into psauthitem select distinct 'READONLY',MENUNAME,BARNAME,BARITEMNAME,PNLITEMNAME,1,15 from psauthitem
2 /
3371 rows created.
SQL> update psauthitem set DISPLAYONLY=0,AUTHORIZEDACTIONS=4 where classid='READONLY' and menuname like 'WEBLIB_%'
2 /
364 rows updated.
SQL> delete from PSAUTHPRCS where classid = 'READONLY'
2 /
12 rows deleted.
SQL> insert into PSAUTHPRCS select distinct 'READONLY',prcsgrp from PSAUTHPRCS
2 /
12 rows created.
SQL>
2) Created custom role and attached permission list REAONLY to it.