最初由 yangtingkun 发布
[B]给zz_zzzd用户create table权限
查询DBA_SYNONYMS看看两个用户的同义词是否指向一个对象 [/B]
Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0
Connected as system
SQL> grant create any table to zz_zzzd;
Grant succeeded
SQL> grant create any table to zz_webcs;
Grant succeeded
SQL>
都授权了
但是其中一个报
ORA-01039 : insufficient privileges on underlying objects of the view
另一个报
Error creating plan table:
ORA-01950: no privileges on tablespace 'USERS'
另一个问题我发现了
Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0
Connected as system
SQL> select * from dba_synonyms where synonym_name=upper('v_bill_s0001');
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------
INTF_WEBCS V_BILL_S0001 INTF V_WEBCS_BILL_S0001 IBSSF
PUBLIC V_BILL_S0001 INTF V_WEBCS_BILL_S0001
ZZ_ZZZD V_BILL_S0001 INTF V_WEBCS_BILL_S0001
LY_ZZZD V_BILL_S0001 INTF V_WEBCS_BILL_S0001
NP_WEBCS V_BILL_S0001 INTF V_WEBCS_BILL_S0001 IBSSF
NP_ZZZD V_BILL_S0001 INTF V_WEBCS_BILL_S0001
ND_WEBCS V_BILL_S0001 INTF V_WEBCS_BILL_S0001 IBSSF
FFYEQ V_BILL_S0001 INTF V_WEBCS_BILL_S0001 IBSSF
PT_WEBCS V_BILL_S0001 INTF V_WEBCS_BILL_S0001 IBSSF
ZZ_WEBCS V_BILL_S0001 INTF V_WEBCS_BILL_S0001 IBSSF
LY_WEBCS V_BILL_S0001 INTF V_WEBCS_BILL_S0001 IBSSF
SM_WEBCS V_BILL_S0001 INTF V_WEBCS_BILL_S0001 IBSSF
12 rows selected
SQL>
原来一个是有数据链,一个是没有,原来这么阴险啊,呵呵,不是一个对象