oracle授权创建视图用dba身份授权:grant create any view to scott用scott创建视图:create view testview
oracle授权创建视图 用dba身份授权: grant create any view to scott 用scott创建视图: create view testview as select empno,ename from emp; 确认test是表还是视图: select object_type from user_objects where object_name='test';