Sql代码 www.2cto.com
--'用户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';