用另一个用户登录sql*plus,grant select on tbname to username; connect username/pw select * from uname.tbname; 也可以创建同义词 create public synonym tbname foor uname.tbname ; 就可以这样用了: select * from tbname;
in PL/SQL block, if you want to refer to an object belongs to other schema, you have to have EXPLICIT access right granted. that means, you have to logon as object owner(another user) and grant right. like,conn user1/password grant select on mytable to user2;try...
connect username/pw
select * from uname.tbname;
也可以创建同义词
create public synonym tbname foor uname.tbname ;
就可以这样用了:
select * from tbname;
grant select on mytable to user2;try...
grant select table a to pp02或者grant select any table to pp02