--INSERT STATEMENTS FOR USER RIGHTS
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1909021'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1906119'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1903080'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1811040'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1804000'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1911098'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1812015'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1910097'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1907010'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1905090'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1806000'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1905000'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1905055'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1910012'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1908063'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1805011'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1903017'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1909100'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1904096'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1911033'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1908046'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1903178'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1904003'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1909137'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1905045'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1810057'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1904024'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1909076'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1903129'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1908106'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102017,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102017 AND SHORT_NAME = '1907005'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'BIGMATG'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'BIGMATH'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'EMB'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'DCRESOU'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'DELAHAY'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102018,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102018 AND SHORT_NAME = 'DECLHAR'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102018,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102018 AND SHORT_NAME = 'DECLTIE'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102018,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102018 AND SHORT_NAME = 'DECLDEI'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'DRANANT'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'DRANAGR'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'GEDCOLL'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'GOBANDE'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'GOBGHLI'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'GOBNIVE'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'GOBSOIG'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'GOBSTRE'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'GOBTUBI'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'TIELENG'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'HOLAVEL'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'JOASSIN'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'LIPPENS'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'LOMMATB'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'MATEGRO'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'MINERAB'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'MULTIGE'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'NHMBRUG'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102018,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102018 AND SHORT_NAME = 'NHMOOST'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102018,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102018 AND SHORT_NAME = 'NHMIZEG'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102018,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102018 AND SHORT_NAME = 'NHMNIEW'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'NHMWIEL'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'SONIARQ'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'TONIMAT'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'VERHEOU'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'ZANDLUM'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'ZANDROE'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'GOBROUC'));
INSERT INTO GU_OC_POI (GUI_USER_ID,OC_POI_CATEGORY,POI_ID) VALUES (101001,102019,(SELECT POI_ID FROM OC_POI WHERE OC_POI_CATEGORY_ID = 102019 AND SHORT_NAME = 'VERHEDR'));

--COMMIT;