SYS WITHOUT ADMIN OPTION
select * from dba_sys_privs where privilege LIKE '%SYNONY%' AND GRANTEE ='SYS';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
SYS CREATE PUBLIC SYNONYM NO
SYS CREATE SYNONYM NO
SYS DROP PUBLIC SYNONYM NO
SYS DROP ANY SYNONYM NO
SYS CREATE ANY SYNONYM NO
Any ideas?