Message PRF0167E User not authorized for requested function - Accessing ADMIN privileges

Document ID : KB000051127
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

User is trying to access the ADMIN privileges and is unable to access the System Profile or the User Profile. The former Administrator is no longer with the company.
The PRF0167E message indicates that the proper authorization is not given to the user and therefore the user cannot perform the requested function.

Solution:

The Administrator option is set within the User Profile.

First it must be determined who has User Profile access. This can be accomplished by executing the following SQL:

 
SELECT PRF_ID, PRF_TYPE                                        
      ,SUBSTR(PRF_DATA,639,1) AS ACCESS_CICS                   
      ,SUBSTR(PRF_DATA,640,1) AS ACCESS_IMS                    
      ,SUBSTR(PRF_DATA,641,1) AS ACCESS_TSO                    
  FROM PTI.PTPRF_LIB_ver  
WHERE ( PRF_TYPE = 'USER'                    
     OR PRF_TYPE = 'GRP ' )                  
  AND ( SUBSTR(PRF_DATA,639,1) = 'Y'         
     OR SUBSTR(PRF_DATA,640,1) = 'Y'         
     OR SUBSTR(PRF_DATA,641,1) = 'Y' );

Secondly, update the User Profile access for a specific user. This can be accomplished by executing the following SQL:

 
UPDATE PTI.PTPRF_LIB_ver                    -- Where Ver is the version of the tool, i.e. 1105, 1200, 1400?              
   SET PRF_DATA = SUBSTR(PRF_DATA,001,638) ||                                  
                  'YYY'                    ||     
                  SUBSTR(PRF_DATA,642    )                                     
 WHERE PRF_ID   = 'your user ID'                  -- replace with your TSO ID  
   AND PRF_TYPE = 'USER'                                                       
;