Checking a Subset In or Out of the Encyclopedia › Recover from Scoping Errors › Identify Protection Downgrades › SQL to Check Protection Level

SQL to Check Protection Level

SELECT OT_MNEMONIC, SE_CKO_STATUS, PROP_CHAR_VAL
FROM
DMDL, SOBJ, DSUBID, DSUBEX, DPRP
WHERE
MODEL_NAME = 'CBS SRVS SURVEY SYSTEM-DEVL'
AND S_MODEL_ID = MODEL_ID
AND S_SUBSET_NAME = 'SUBJECT AREAS'
AND SE_SUBSET_ID = S_SUBSET_ID
AND OT_OBJ_CODE = SE_OBJ_TYPE
AND PROP_OBJ_ID = SE_OBJ_ID
AND PROP_TYPE_CODE = 224
ORDER BY OT_MNEMONIC, PROP_CHAR_VAL