需求描述:
Oracle中建立一个用户fm,使fm用户只具备访问视图fm_view的权限。
-----------------------------------------------------------------------------------------
1、建立一个用户fm密码fm默认表空间WORKSHEET
create user fm identified by fm default 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 on ly;
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 on ly;
5、此时用fm用户登录后select * from fm_view即可。
Oracle中建立一个用户fm,使fm用户只具备访问视图fm_view的权限。
-----------------------------------------------------------------------------------------
1、建立一个用户fm密码fm默认表空间WORKSHEET
create user fm identified by fm default 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 on
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 on
5、此时用fm用户登录后select * from fm_view即可。