连接数据库
conn / as sysdba
创建视图
create or replace view user_view_src as select * from biblios;
创建用户1
create user v_user1 identified by v_user1;
授予创建连接、查询该视图的权限
grant create session,resource to v_user1;
grant select on view user_view_src to v_user1;
登录该用户,检查是否能查询该视图
conn v_user1/v_user1
select count(*) from user_view_src;