Oracle + dbunit AmbiguousTableNameException 解决

-- Unitils加载元数据

SELECT NULL AS table_cat,

o.ownerAS table_schem,

o.object_nameAS table_name,

o.object_typeAS table_type,

NULL AS remarks

FROM all_objects o

WHERE o.ownerLIKE '%' ESCAPE '/'

    AND o.object_nameLIKE '%' ESCAPE '/'

    AND o.object_typeIN ('xxx','TABLE')

ORDER BY table_type, table_schem, table_name;

-- 查询当前用户的查询表权限

select * from user_tab_privs;

 表明 FROM 被赋权的owner;