Summary

Resolution

Below are steps to alter security permissions related to requestor management:
 
1. Navigate to <PRPC_distribution_dir>\archives and extract the "pegadbinstall-classes.zip" to a temp folder.
 
2. Locate and extract the "prmbeans.properties" file under the temp/lib/pega/prresources.jar.
 
3. Modify the prmbeans.properties file values as per your requirement and recreate the prresources.jar with this newly modified prmbeans.properties (following values are modified according to the requirement).
 
#Default MBean security configuration.
deny.DatabaseManagement.DatabaseConnectionDetails = false
deny.RequestorManagement.RequestorDetails = false
deny.RequestorManagement.Clipboard = false
 
By default, the value is a "true", denying you access to the Clipboard / Details.
 
4. Login to the PRPC Developer portal, navigate to Pega > Application > Distribution > Import menu.
 
5. Click Browse and select the prresources.jar modified in Step 3 above and click Next.
 
6. In the Codeset Name/Version screen, specify Codeset Name as "Customer" and Codeset Version as "07-10-15" and click "Next". To complete the installation click "Done".
 
7. Stop the PRPC server/JVM.
 
8. Login to the PRPC database as the PRPC schema owner and execute the following SQL command.
 
SQL > update pr_engineclasses set pzcodeset='pega-enginecode' where pzclass like 'prmbeans%' and pzcodeset='Customer';
SQL > commit;
 
9. Restart the PRPC server/JVM.

If still not able to use the updated prmbeans.properties file, then you can perform the following steps.

1. Run below query:

SQL > select * from pr_engineclasses where pzcodeset='pega-enginecode' and pzclass like 'prmbeans%';

2. If one witness mutiple entries of 'prresources.jar' file with pzcodeset name as 'pega-enginecode' from the above query, filter out the latest prresources.jar entry by running select statement for 'pzlastmodified' , check the latest date entered in 'pzlastmodified' (it should be the one when you have imported prresources.jar file newly with the updated prmbeans.properties).

3. Use the same last modified date as filter to pick the other prresource.jar entries other than your latest prresource.jar one.

For example, if the date  imported the prresources.jar file was '19-05-2015', one can run update statement as follows, which will pick and update the other prresource.jar entries other than your latest prresource.jar one.

SQL> select * from pr_engineclasses  where pzclass like 'prmbeans%' and pzlastmodified < To_Date('19-05-2015','dd-mm-yyyy'); 
SQL > update pr_engineclasses set pzcodeset='Customer' where pzclass like 'prmbeans%' and pzlastmodified < To_Date('19-05-2015','dd-mm-yyyy');
SQL > commit;
 
4. Restart the PRPC server/JVM.