1、创建用户
create user username identified by password
2、授权
grant create session to username ;
grant select on view_sys_table to username ;
3、创建视图
create or replace view view_sys_table as select * from dual
这样通过username 登陆后,通过select * from xxx.view_sys_table