以dba用户登录 sqlplus / as sysdba 赋予scott用户创建VIEW的权限 grant create view to user1 以user1用户登录oracle conn user1/user1 创建视图成功 CREATE OR REPLACE VIEW viewTest AS SELECT * FROM emp where deptno = 18;