-- 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;
