ORACLE（OceanBase兼容）创建跨SCHEMA的同义词

SELECT 
    'CREATE OR REPLACE SYNONYM ' 
    || REPLACE(owner, '_OWNER', '_MAINT') || '.' || table_name
    || ' FOR ' || owner || '.' || table_name || ';' AS sql_stmt
FROM all_tables
WHERE owner LIKE '%\_OWNER' ESCAPE '\'
  AND owner NOT IN ('SYS','SYSTEM','OUTLN','DBSNMP','ORDSYS','CTXSYS','XDB','MDSYS','WMSYS','EXFSYS')
ORDER BY owner, table_name;




SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' 
       || owner || '.' || table_name 
       || ' TO ' || REPLACE(owner,'_OWNER','_MAINT') || ';' AS grant_stmt
FROM all_tables
WHERE owner LIKE '%\_OWNER' ESCAPE '\'
  AND owner NOT IN ('SYS','SYSTEM','OUTLN','DBSNMP','ORDSYS','CTXSYS','XDB','MDSYS','WMSYS','EXFSYS')
ORDER BY owner, table_name;

本文标题：ORACLE（OceanBase兼容）创建跨SCHEMA的同义词
本文连接：https://blog.dextercai.com/archives/246.html
除另行说明，本站文字内容采用创作共用版权 CC-BY-NC-ND 4.0 许可协议，版权归本人所有。
除另行说明，本站图片内容版权归本人所有，未经许可前，严禁以任何形式的使用。

---

即日起视情况关闭全站评论区，您可以通过关于页面的电邮地址和我取得联系，谢谢