PS_SEC_BU_OPR Script

—Oracle Sql
—grant “NewOPRID” user rights to the same BUs as “CloneOPRID” user has access to
INSERT INTO PS_SEC_BU_OPR (OPRID, BUSINESS_UNIT) SELECT ‘NewOPRID’, BUS FROM (SELECT DISTINCT BUSINESS_UNIT BUS FROM PS_SEC_BU_OPR WHERE OPRID = ‘CloneOPRID’)
COMMIT

—grant access to user “YourOPRID” to the rest of the BUs available in the environment
INSERT INTO PS_SEC_BU_OPR (OPRID, BUSINESS_UNIT) (SELECT OPRID,BUSINESS_UNIT FROM (SELECT ‘YourOPRID’ OPRID FROM DUAL), (SELECT BUSINESS_UNIT FROM (select BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_FS) MINUS (SELECT DISTINCT BUSINESS_UNIT BUS FROM PS_SEC_BU_OPR WHERE OPRID = ‘YourOPRID’)))
COMMIT