1、建立一个用户fm密码fm默认表空间WORKSHEET
create user fm identified by fm defalut tablespace WORKSHEET;
2、权限，只授予connect和select和create any view权限
grant
create session,create any view,select any table
to fm
3、用eomsdb用户登录建立视图
create or replace view to_fm_view as
(select * from wf_task)
with read only;
grant select on to_fm_view to fm
4、用fm用户登录再建立视图
create or replace view fm_view as
(select * from eomsdb.to_fm_view)
with read only;
5、此时用fm用户登录后select * from fm_view即可
| 网站地图 |