关于synonym的一个疑问


oracle 10g里,用A用户删除B用户的表分区。TTT是B用户的表，A用户建了同义词
在A用户下

create synonym ttt for B.ttt;

select * from ttt;查询表OK
alter table ttt truncate partition P200809报错， ORA-00942: table or view does not exist

请问DX,这种情况是否正常,创建了synonym后,是否可以alter 或drop 基表,感觉不像是权限的问题,因为我把select an table,alter any table,dba都给A用户了,还是不可以.

印象中，好像需要显式授权。直接用B用户给A用户授权试试。

SQL Reference about "CREATE SYNONYM" says "You can refer to synonyms in the following DDL statements: AUDIT, NOAUDIT, GRANT, REVOKE, and COMMENT." Note that "ALTER" is not in the allowed DDL list.

Yong Huang

崇拜下版主~~