|
SELECT DISTINCT SU.OPRID ,SU.BUSINESS_UNIT FROM PS_SEC_BU_OPR SU ,PS_BUS_UNIT_TBL_GL B1 , PS_INSTALLATION_FS I1 WHERE SU.BUSINESS_UNIT = B1.BUSINESS_UNIT AND I1.SECURITY_TYPE = 'O' AND I1.BU_SECURITY = 'Y' UNION SELECT DISTINCT OP.OPRID ,SC.BUSINESS_UNIT FROM PS_SEC_BU_CLS SC ,PS_BUS_UNIT_TBL_GL B2 ,PS_INSTALLATION_FS I2 ,PSOPRDEFN OP WHERE SC.BUSINESS_UNIT = B2.BUSINESS_UNIT AND OP.OPRCLASS = SC.OPRCLASS AND I2.SECURITY_TYPE = 'C' AND I2.BU_SECURITY = 'Y' UNION SELECT DISTINCT 'ALLUSERS' AS OPRID ,B3.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_GL B3 , PS_INSTALLATION_FS I3 WHERE I3.SECURITY_TYPE = 'N' OR I3.BU_SECURITY = 'N' UNION SELECT 'ALLUSERS' AS OPRID , ' ' AS BUSINESS_UNIT FROM PS_INSTALLATION_FS
|
USERID