正确使用: sql>connect bb/bb@server_str sql>grant select on aa.aatest_1 to bb; sql>CREATE SYNONYM MYTONGYI FOR AA.AATEST_1; sql>select * from mytongyi;同义词相当于别名,参与: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_72a.htm#SQLRF01401
sql>connect bb/bb@server_str
sql>grant select on aa.aatest_1 to bb;
sql>CREATE SYNONYM MYTONGYI FOR AA.AATEST_1;
sql>select * from mytongyi;同义词相当于别名,参与:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_72a.htm#SQLRF01401