PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to create read only user for PeopleTools 8.54.13

edited Aug 27, 2015 10:10AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center