不同用户间创建视图提示权限不足,解决方法

场景:

     同一数据库K, 有A用户和 B用户 , 现在A用户要建立一张B用户下的某表tab.

    提示错误的原因:A用户没有查询B用户下表的权限.

 

SQL> conn sys/a as sysdba; Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 Connected as SYS SQL> create user a identified by a; User created SQL> grant create session,connect to a; Grant succeeded SQL> grant select on w.a to a; Grant succeeded SQL> grant create view to a; Grant succeeded SQL> conn a/a; Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 Connected as a SQL> select * from w.a; MM NN ---------- ---- 10 飞机 10 汽车 10 轮船 SQL> create view t_views as select * from w.a; View created SQL>