创建同义词

SELECT 'GRANT SELECT ON '

||TNAME||' TO USERNAME;' FROM TAB;

GRANT SELECT ON dev.T_CHAXUNMK TO taobo;

CREATE public SYNONYM
T_CHAXUNMK FOR dev.T_CHAXUNMK;

SELECT 'CREATE SYNONYM

'||TNAME||' FOR USERNAME.'||TNAME||';' FROM TAB;

select * from T_CHAXUNMK1