-- Unitils加載元數(shù)據(jù)
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;
-- 查詢當(dāng)前用戶的查詢表權(quán)限
select * from user_tab_privs;
?表明 FROM 被賦權(quán)的owner;
