--                                                  ========================
--                                                  === SRC_ZOOM_INFO_TB ===
--                                                  ========================
/*
--========= SRC_ZOOM_INFO_TB
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V3_TB TO USER_OTHQ;
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V3_TB TO ZOOM_USER_EXTERNAL;
CREATE OR REPLACE SYNONYM ZOOM_USER_EXTERNAL.ZOOM_INFO_TB for OTHQ_OWN.SRC_ZOOM_INFO_V3_TB;
CREATE OR REPLACE SYNONYM USER_OTHQ.ZOOM_INFO_TB for OTHQ_OWN.SRC_ZOOM_INFO_V3_TB;
CREATE OR REPLACE SYNONYM OTHQ_OWN.ZOOM_INFO_TB for OTHQ_OWN.SRC_ZOOM_INFO_V3_TB;


--========= SRC_ZOOM_INFO_TB
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V4_TB TO USER_OTHQ;
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V4_TB TO ZOOM_USER_EXTERNAL;
CREATE OR REPLACE SYNONYM ZOOM_USER_EXTERNAL.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V4_TB;
CREATE OR REPLACE SYNONYM USER_OTHQ.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V4_TB;
CREATE OR REPLACE SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V4_TB;


--========= SRC_ZOOM_INFO_TB
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V5_TB TO USER_OTHQ;
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V5_TB TO ZOOM_USER_EXTERNAL;
CREATE OR REPLACE SYNONYM ZOOM_USER_EXTERNAL.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V5_TB;
CREATE OR REPLACE SYNONYM USER_OTHQ.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V5_TB;
CREATE OR REPLACE SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V5_TB;


--========= SRC_ZOOM_INFO_TB
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V6_TB TO USER_OTHQ;
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V6_TB TO ZOOM_USER_EXTERNAL;
CREATE OR REPLACE SYNONYM ZOOM_USER_EXTERNAL.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V6_TB;
CREATE OR REPLACE SYNONYM USER_OTHQ.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V6_TB;
CREATE OR REPLACE SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V6_TB;
*/


--========= SRC_ZOOM_INFO_TB
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_V7_TB TO USER_ZOOM_INFO;
CREATE OR REPLACE SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_UPDATED_TB for OTHQ_OWN.SRC_ZOOM_INFO_V7_TB;
--after import
CREATE OR REPLACE SYNONYM USER_ZOOM_INFO.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V7_TB;
CREATE OR REPLACE SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_TB for OTHQ_OWN.SRC_ZOOM_INFO_V7_TB;
DROP SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_UPDATED_TB


--========= SRC_ZOOM_INFO_VALUABLE_TB
GRANT SELECT ON OTHQ_OWN.SRC_ZOOM_INFO_VALUABLE_V7_TB TO USER_ZOOM_INFO;
CREATE OR REPLACE SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_VALUABLE_UPDATED_TB for OTHQ_OWN.SRC_ZOOM_INFO_VALUABLE_V7_TB;
--after import
CREATE OR REPLACE SYNONYM USER_ZOOM_INFO.ZOOM_INFO_NEW_FORMAT_VALUABLE_TB for OTHQ_OWN.SRC_ZOOM_INFO_VALUABLE_V7_TB;
CREATE OR REPLACE SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_VALUABLE_TB for OTHQ_OWN.SRC_ZOOM_INFO_VALUABLE_V7_TB;
DROP SYNONYM OTHQ_OWN.ZOOM_INFO_NEW_FORMAT_VALUABLE_UPDATED_TB
