oracle:
user1把表t1的select权限授权给user2之后,user2查询t1需要用语句
select * from user1.t1;
user2创建同义词
create or replace synonym t1 for user1.t1;
之后就可以用select * from t1查询数据;
oracle:
user1把表t1的select权限授权给user2之后,user2查询t1需要用语句
select * from user1.t1;
user2创建同义词
create or replace synonym t1 for user1.t1;
之后就可以用select * from t1查询数据;