-- 1. 모든 계정이 사용할 수 있는 SYNONYM
--------------------------------------------------------------------------
CREATE OR REPLACE PUBLIC SYNONYM IF_ESAUSER FOR SMARTX.IF_ESAUSER;
DROP PUBLIC SYNONYM IF_ESAUSER;


-- 2. HGPSIF 계정만 사용할 수 있는 SYNONYM
--------------------------------------------------------------------------
CREATE OR REPLACE SYNONYM HGPSIF.IF_ESAUSER FOR SMARTX.IF_ESAUSER;
DROP SYNONYM HGPSIF.IF_ESAUSER;


SELECT * FROM ALL_SYNONYMS;