1.创建用户
sqlplus /nolog
conn /as sysdba;
create user smart identified by smart;
select * from all_users;
2.授予权限
grant create session to smart;
grant unlimited tablespace to smart;
grant create any view to smart;
3.登录另一用户,为新建用户smart授予访问指定表的权限
sqlplus tianzhi_smart/tianzhi_smart@localhost:1521/orcl
grant select on zh_major_item to smart;
4.登录新建用户smart,创建视图
//登录smart用户
sqlplus smart/smart@localhost:1521/orcl
//测试是否可以访问tianzhi_smart用户下的zh_major_item表
select * from tianzhi_smart.zh_major_item;
//创建视图
create or replace force view vw_major_item
AS Select * from tianzhi_smart.zh_major_item
WITH READ ONLY;
//测试视图是否创建成功
//观察是否与 select * from tianzhi_smart.zh_major_item;查询结果相同
select * from vw_major_item;