SQL> grant create any view to testuser;
Grant succeeded.
SQL> grant create view to testuser;
Grant succeeded.
SQL>conn testuser/testuser
Connected.
SQL> create view testuser2.testview3 as select * from test;
View created.
login as sys:
SQL> revoke create any view from testuser;
Revoke succeeded.
SQL> conn testuser/testuser
Connected.
SQL> create view testuser2.testview4 as select * from test;
create view testuser2.testview4 as select * from test
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> create view testuser.testview4 as select * from test;
View created.