Oracle 查看用户的表级权限和同义词

--Oracle 查看用户的表级权限

SELECT *

FROM user_tab_privs u

WHERE u.table_name LIKE '%CUX_OM_SHIPMENTS_HDR_IFACE%';

 

--Oracle 查看用户的表级同义词

SELECT *

FROM user_synonyms u

WHERE u.synonym_name LIKE '%CUX_OM_SHIPMENTS_HDR_IFACE%';