--                    ===============================================
--                    === SRC_OSEARCH_WEBSERVICESEXECUTION_MCP_TB ===
--                    ===============================================
-- TB
GRANT SELECT ON OTHQ_OWN.SRC_OSEARCH_WEBSERVICESEXECUTION_MCP_TB TO USER_MCP;
CREATE OR REPLACE SYNONYM USER_MCP.OSEARCH_WEBSERVICESEXECUTION_MCP_TB for OTHQ_OWN.SRC_OSEARCH_WEBSERVICESEXECUTION_MCP_TB;

--                    =================================================
--                    === SRC_NLCORP_PRODUCTION_ACCOUNTS_MAPPING_TB ===
--                    =================================================
-- TB
GRANT SELECT ON OTHQ_OWN.SRC_NLCORP_PRODUCTION_ACCOUNTS_MAPPING_TB TO USER_MCP;
CREATE OR REPLACE SYNONYM USER_MCP.NLCORP_PRODUCTION_ACCOUNTS_MAPPING_TB for OTHQ_OWN.SRC_NLCORP_PRODUCTION_ACCOUNTS_MAPPING_TB;

--                    ==================================
--                    === SRC_NLCORP_CUSTOMER_MCP_TB ===
--                    ==================================
-- TB
GRANT SELECT ON OTHQ_OWN.SRC_NLCORP_CUSTOMER_MCP_TB TO USER_MCP;
CREATE OR REPLACE SYNONYM USER_MCP.NLCORP_CUSTOMER_MCP_TB for OTHQ_OWN.SRC_NLCORP_CUSTOMER_MCP_TB;

--                    ======================================
--                    === SRC_SMD_ACCOUNTS_LOCAL_DCID_TB ===
--                    ======================================
-- TB
GRANT SELECT ON OTHQ_OWN.SRC_SMD_ACCOUNTS_LOCAL_DCID_TB TO USER_MCP;
CREATE OR REPLACE SYNONYM USER_MCP.SMD_ACCOUNTS_LOCAL_DCID_TB for OTHQ_OWN.SRC_SMD_ACCOUNTS_LOCAL_DCID_TB;
-- VW
GRANT SELECT ON OTHQ_OWN.SMD_ACCOUNTS_LOCAL_DCID_PRODUCTION_VW TO USER_MCP;
CREATE OR REPLACE SYNONYM USER_MCP.SMD_ACCOUNTS_LOCAL_DCID_PRODUCTION_VW for OTHQ_OWN.SMD_ACCOUNTS_LOCAL_DCID_PRODUCTION_VW;

--                    ===========================================
--                    === NLCORP_MCP_CUSTOMER_CONSOLIDATED_VW ===
--                    ===========================================
-- VW
GRANT SELECT ON OTHQ_OWN.NLCORP_MCP_CUSTOMER_CONSOLIDATED_VW TO USER_MCP;
CREATE OR REPLACE SYNONYM USER_MCP.NLCORP_MCP_CUSTOMER_CONSOLIDATED_VW for OTHQ_OWN.NLCORP_MCP_CUSTOMER_CONSOLIDATED_VW;

--                    ==================================
--                    === SRC_OSEARCH_LOGLONG_MCP_TB ===
--                    ==================================
-- TB
GRANT SELECT ON OTHQ_OWN.SRC_OSEARCH_LOGLONG_MCP_TB TO USER_MCP;
CREATE OR REPLACE SYNONYM USER_MCP.OSEARCH_LOGLONG_MCP_TB for OTHQ_OWN.SRC_OSEARCH_LOGLONG_MCP_TB;
