Oracle中如果建立VIEW基于其它用户的表?
Oracle中如果建立VIEW基于其它用户的表?
Oracle 中, 有用户USERA, USERB, USERA中有表TABLE_AA
create table_aa (
userID varchar2(10),
...
);
grant all on table_aa to USERB;
可否在USERB下建立如下视图?
CREATE OR REPLACE VIEW VTABLE_AA
AS
select * from USERA.TABLE_AA where userID=12;
但系统提示出错
ORA-00942: table or view does not exist
以下语句
select * from USERA.TABLE_AA where userID=12;
正常,有结果返回.
请问是何原因?
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.2.1 Production
TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production