2. Tech
  3. Create synonym

Create synonym

xiaoxiao2021-03-06  61

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

转载请注明原文地址:https://www.9cbs.com/read-114621.html

9cbs

New Post(0)