先创建一个表在lixw用户下
create table teach(id int ,name varchar2(100));
创建同义词
create public synonym teach for teach;
赋予权限给对应的用户
grant all on teach to public
然后lipf登陆
select * from teach;
可见在多个用户下共享表挺有用的。
create table teach(id int ,name varchar2(100));
创建同义词
create public synonym teach for teach;
赋予权限给对应的用户
grant all on teach to public
然后lipf登陆
select * from teach;
可见在多个用户下共享表挺有用的。