数据库表授权和建同义词

--'用户2'可以对'用户1'的'表1'进行查询\插入\修改\删除\索引\修改
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER,
 ON COMMIT REFRESH ON '用户1'.'表1' TO '用户2';

GRANT QUERY REWRITE ON '用户1'.'表1'
TO '用户2' WITH GRANT OPTION;

--建同义词
CREATE OR REPLACE PUBLIC SYNONYM '表1'
FOR '用户1'.'表1';