1.SYSTEM(DBA)执行:
GRANT CREATE ANY SYNONYM TO ORCL_OWNER
2.ORCL_OWNER用户执行:
CREATE SYNONYM "ORCL_QUERY"."T_TABNAME" FOR "ORCL_OWNER"."T_TABNAME"
3.ORCL_OWNER用户执行:
GRANT SELECT ON ORCL_OWNER.T_TABNAME TO ORCL_QUERY
GRANT CREATE ANY SYNONYM TO ORCL_OWNER
2.ORCL_OWNER用户执行:
CREATE SYNONYM "ORCL_QUERY"."T_TABNAME" FOR "ORCL_OWNER"."T_TABNAME"
3.ORCL_OWNER用户执行:
GRANT SELECT ON ORCL_OWNER.T_TABNAME TO ORCL_QUERY