SET FEED OFF
set HEADING off
SELECT '---------SINONIMOS--------' FROM DUAL;
SET FEED ON
set HEADING on

select * from dba_synonyms
where table_owner = upper('&1')
and table_name = upper('&2')
order by owner,synonym_name;

BREAK ON GRANTEE NODUP

SET FEED OFF
set HEADING off
SELECT '---------PRIVILEGIOS--------' FROM DUAL;
SET FEED ON
set HEADING on

select grantee,privilege,owner,table_name,grantable,hierarchy from dba_tab_privs
where owner = upper('&1')
and table_name = upper('&2')
order by grantee,privilege;

CLEAR BREAK