Description:
Doing a RECOVER DROPPED OBJECT SECURITY (Option R) display in RC/Secure allows you to recover object authorities that were dropped outside of SRS. You must be an administrator named at installation time, RCSADM or RCSADM2 to perform this function.
Solution:
The RECOVER DROPPED OBJECT SECURITY option reads the PTI.PTRCS_APLDIM_0200 table to get the records.
SELECT DISTINCT OBJTYPE, OBJNAME, QUALIFIER FROM PTI.PTRCS_APLDOM_0200 WHERE DB2ID LIKE :HDB2ID AND DEPT LIKE :HDEPT AND OBJNAME LIKE :HNAME AND QUALIFIER LIKE :HQUAL AND OBJTYPE LIKE :HTYPE AND OBJTYPE ^= 'SY' AND AUTHS ^= '' ;
Release:
Component: RCSDB2