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